Fernando <[EMAIL PROTECTED]> writes: > Is it possible to do this? > SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
SELECT COUNT(colname) > 0 AS colname FROM table;
If you really like to type, you could use a CASE expression.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
