Andrus wrote:
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.
Use bool_or(boolean) instead.
Bye
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
