The following bug has been logged online:
Bug reference: 1371
Logged by: Aguinaldo Possatto
Email address: [EMAIL PROTECTED]
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
