Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > On Wed, 04 May 2005 11:52:32 +1000, Neil Conway <[EMAIL PROTECTED]> wrote: >> I don't understand. Can you explain what the problem is? > I think they mean that it doesn't do short-circuit evaluation. AFAICS the claimed example cannot exhibit any different

Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Klint Gore
On Wed, 04 May 2005 11:52:32 +1000, Neil Conway <[EMAIL PROTECTED]> 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\', w

Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Neil Conway
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,

[BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread tirny
The following bug has been logged online: Bug reference: 1644 Logged by: tirny Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: FreeBSD 5.3 Description:control structeres perfomance in pgsql Details: for example, look at this code: any c