Re: BOOLEAN question

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 ...);
> > >