Re: BOOLEAN question

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: Josh Berkus <josh(at)agliodbs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: BOOLEAN question
Date: 2002-10-30 16:38:18
Message-ID: 3DC00AFA.3992DF0F@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...);
> > >

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2002-10-30 16:42:43 unnecessary updates
Previous Message Jean-Luc Lachance 2002-10-30 16:26:11 Re: BOOLEAN question