Re: Conditional on Select List

[Fernando <fernando@xxxxxxxxxx>]

Thanks this is exactly what I need it.

Fernando

Tom Lane wrote:

Fernando <fernando@xxxxxxxxxx> 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