Postgres Pro
Downloads
Home   >   mailing lists

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

From Fernando
Subject Re: Conditional on Select List
Date
Msg-id 4829C472.7080006@ggtours.ca
Whole thread Raw
In response to Re: Conditional on Select List  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Thanks this is exactly what I need it.

Fernando

Tom Lane wrote: 
Fernando <fernando@ggtours.ca> 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

pgsql-general by date:

Previous
From: "J. Manuel Velasco - UBILIBET"
Date:
Subject: Re: change encoding
Next
From: "J. Manuel Velasco - UBILIBET"
Date:
Subject: how can i get initdb