Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Conditional on Select List
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Fernando <fernando(at)ggtours(dot)ca>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Conditional on Select List
- Date: Tue, 13 May 2008 12:07:37 -0400
- Message-id: <26817(dot)1210694857(at)sss(dot)pgh(dot)pa(dot)us>
Fernando <fernando(at)ggtours(dot)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
- Follow-Ups:
- Re: Conditional on Select List
- From: Fernando
- Re: Conditional on Select List
- References:
- Conditional on Select List
- From: Fernando
- Conditional on Select List
- 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
- Indexes: