Re: [GENERAL] Conditional on Select List

[Richard Broersma]

On Tue, May 13, 2008 at 8:52 AM, Fernando <[EMAIL PROTECTED]> wrote:
> SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;

A rewrite of this query might do what you want:

SELECT colname_cnt > 0 AS Greaterthanzero
  FROM ( SELECT COUNT( colname ) AS colname_cnt
           FROM Table );

or

SELECT CASE COUNT( colname )
       WHEN > 0
       THEN TRUE
       ELSE FALSE
       END AS GreaterThanZero
  FROM Table;
-- 
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general