Conditional on Select List

[Fernando <fernando@xxxxxxxxxx>]

Is it possible to do this?

SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;

What I want is to return a boolean, but when I tried SELECT COUNT(colname)::BOOLEAN FROM table; it says it cannot cast bigint to boolean.

Is there such IF function or do I have to create my own.

Thank you.