Re: bool from aggregate

Hi, Am 25.01.2017 um 11:29 schrieb Stefano Fioravanzo:

Hello,

I would like to know if there is a way to replicate the behavior of the bool_and function of Postgresql. An example of its use is the following:

SELECT bool_and(A) FROM mytable GROUP BY B;

bool_and will return true if all values in the group are true, false otherwise. I would like to do the same thing in monetdb. The MIN and MAX aggregates act as AND and OR, e.g.: SELECT MIN(v) from (VALUES (TRUE),(FALSE)) AS t(v)

Regards, Moritz