Postgres Pro
Downloads
Home   >   mailing lists

Re: if exists select ... in plpgsql code - Mailing list pgsql-general

From Roland Roberts
Subject Re: if exists select ... in plpgsql code
Date
Msg-id m2admo397z.fsf@kuiper.rlent.pnet
Whole thread Raw
In response to Re: if exists select ... in plpgsql code  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

    Tom> Should be "if (exists (select ...))".  Note the parens in
    Tom> SQL92:

Thanks, I should have known that since I had just written a query with
a "where" clause that had exactly that syntax.

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Mailing lists archive search
Next
From: Antti Haapala
Date:
Subject: psql: \pset pager 'always'?