Thanks this is exactly what I need it.
Fernando
Tom Lane wrote:
> Fernando <fernando(at)ggtours(dot)ca> 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
>
>