Re: [GENERAL] Conditional on Select List

[Fernando]

Thanks this is exactly what I need it.

Fernando

Tom Lane wrote:

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