Re: BOOLEAN question - Mailing list pgsql-sql

From Jean-Luc Lachance
Subject Re: BOOLEAN question
Date
Msg-id 3DC00AFA.3992DF0F@nsd.ca
Whole thread Raw
In response to Re: BOOLEAN question  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Of course, I meant

SELECT COALESCE( (SELECT true FROM ... WHERE ...  AND boolcol LIMIT 1),
FALSE);

Jean-Luc Lachance wrote:
> 
> Why not simply:
> 
> SELECT COALESCE( (SELECT true FROM ... WHERE boolcol LIMIT 1), FALSE);
> 
> JLL
> 
> Josh Berkus wrote:
> >
> > Tom,
> >
> > > Perhaps
> > >       SELECT true = ANY (SELECT boolcol FROM ...);
> > > or
> > >       SELECT true IN (SELECT boolcol FROM ...);
> > >


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: BOOLEAN question
Next
From: chester c young
Date:
Subject: unnecessary updates