Re: Conditional on Select List

["Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>]

Fernando wrote:
> 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.

Look up CASE in the docs..

Joshua D. Drake