BUG #1371: Short-circuit evaluation on PL/PgSQL - Mailing list pgsql-bugs

From Aguinaldo Possatto
Subject BUG #1371: Short-circuit evaluation on PL/PgSQL
Date
Msg-id 200501041125.j04BPG0n026668@developer.pgadmin.org
Whole thread Raw
Responses Re: BUG #1371: Short-circuit evaluation on PL/PgSQL
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1371
Logged by:          Aguinaldo Possatto
Email address:      aguinaldo@aswti.com
PostgreSQL version: 8.0
Operating system:   Windows XP
Description:        Short-circuit evaluation on PL/PgSQL
Details:

an exception is raised when this block is being executed:

if ( ((tg_op = 'INSERT') and
        (new.field is not null)) or
    ((tg_op = 'DELETE') and
        (old.field is not null)) )
then
  ...
end if;

the error is :
"SQL Error: ERRO: record "old" is not assigned yet"

but if the evaluation was "short-circuit" this error would not happen.

pgsql-bugs by date:

Previous
From: "Graham Robson"
Date:
Subject: BUG #1372: Service won't start with tcpip_socket = true
Next
From: Andrew Dunstan
Date:
Subject: Re: [pgsql-hackers-win32] More SSL questions..