How to force Postgres to calculate MAX(boolean)

Поиск
Список
Период
Сортировка
I try to convert code from other database to Postgres.

CREATE TABLE test(test BOOLEAN);
SELECT MAX(test) FROM test;

causes error

ERROR:  function max(boolean) does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.

I tried
SELECT MAX(test:integer)::boolean FROM test;

but this casuses error

ERROR:  cannot cast type boolean to integer

I have lot of MAX() functions applied to boolean expressions.

How to force Postgres to calculate MAX(boolean) ?

MAX(boolean) should return true if its argument evaluates true for at least
one row.



В списке pgsql-general по дате отправления: