Re: BUG #1644: control structeres perfomance in pgsql

On Wed, 04 May 2005 11:52:32 +1000, Neil Conway <neilc(at)samurai(dot)com> wrote:
> tirny wrote:
> > any code instructions
> > ***
> > IF FOUND AND TG_OP = 'UPDATE' THEN
> > ***
> > END IF;
> > ***
> >
> > if not found plsql does't break this structure after IF FOUND and proceed
> > TG_OP = \'UPDATE\', what bring control structures to:
> > IF FOUND THEN
> > IF TG_OP = 'UPDATE' THEN
> > ***
> > END IF;
> > END IF;
> >
> > inconveniently, isn't it?
>
> I don't understand. Can you explain what the problem is?

I think they mean that it doesn't do short-circuit evaluation.

[to tirny]
If so, see explanation in the documentation at the bottom of
http://www.postgresql.org/docs/8.0/static/sql-expressions.html

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+