Search Postgresql Archives

Re: Conditional on Select List

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Fernando <fernando@xxxxxxxxxx>
Subject: Re: Conditional on Select List
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 13 May 2008 12:07:37 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Fernando <fernando@xxxxxxxxxx> message dated "Tue, 13 May 2008 11:52:24 -0400"
In-reply-to: <4829B938.1060805@xxxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Conditional on Select List
  - From: Fernando

References:
- Conditional on Select List
  - From: Fernando

Prev by Date: Re: Conditional on Select List
Next by Date: Re: Conditional on Select List
Previous by thread: Re: Conditional on Select List
Next by thread: Re: Conditional on Select List
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux