Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Conditional on Select List
- From: "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
- To: "'Fernando'" <fernando(at)ggtours(dot)ca>, <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Conditional on Select List
- Date: Tue, 13 May 2008 11:07:09 -0500
- Message-id: <008201c8b513$663d2b30$32b78190$(at)r@sbcglobal.net>
> > 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. > How about this? Logic al expresses are already returned as Boolean. Select COUNT(colname) > 0 AS colname FROM table
- 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: