Re: if exists select ... in plpgsql code

From: Roland Roberts <roland(at)astrofoto(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: if exists select ... in plpgsql code
Date: 2002-09-11 14:13:36
Message-ID: m2admo397z.fsf@kuiper.rlent.pnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antti Haapala 2002-09-11 14:14:22 psql: \pset pager 'always'?
Previous Message Michael und Katrin Rudolph 2002-09-11 13:26:02 Table with 90 columns