Home > mailing lists

Re: Conditional on Select List - Mailing list pgsql-general

From	Douglas McNaught
Subject	Re: Conditional on Select List
Date	May 13, 2008 16:15:34
Msg-id	5ded07e00805130909g40dc6f7v2c8f1d22e461eb8c@mail.gmail.com Whole thread Raw
In response to	Conditional on Select List (Fernando <fernando@ggtours.ca>)
List	pgsql-general

Tree view

On Tue, May 13, 2008 at 11:52 AM, Fernando <fernando@ggtours.ca> wrote:
>
>  Is it possible to do this?
>
>  SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;

You should be able to use CASE for this.

-Doug

pgsql-general by date:

From: Tom Lane
Date: 13 May 2008, 16:11:55
Subject: Re: Conditional on Select List

From: Kevin Hunter
Date: 13 May 2008, 16:15:35
Subject: Re: PG -v- MySQL

Re: Conditional on Select List - Mailing list pgsql-general

Previous

Next