Home > mailing lists

Conditional on Select List - Mailing list pgsql-general

From	Fernando
Subject	Conditional on Select List
Date	May 13, 2008 12:54:47
Msg-id	4829B938.1060805@ggtours.ca Whole thread Raw
Responses	Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List
List	pgsql-general

Tree view

Is it possible to do this?

SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;

What I want is to return a boolean, but when I tried SELECT COUNT(colname)::BOOLEAN FROM table; it says it cannot cast bigint to boolean.

Is there such IF function or do I have to create my own.

Thank you.

pgsql-general by date:

From: Dimitri Fontaine
Date: 13 May 2008, 12:52:58
Subject: Re: PG -v- MySQL

From: Tom Lane
Date: 13 May 2008, 12:58:25
Subject: Re: pg_standby / WAL archive-restore through system restarts

Conditional on Select List - Mailing list pgsql-general

Previous

Next