BUG #1371: Short-circuit evaluation on PL/PgSQL

Поиск
Список
Период
Сортировка
От Aguinaldo Possatto
Тема BUG #1371: Short-circuit evaluation on PL/PgSQL
Дата
Msg-id 200501041125.j04BPG0n026668@developer.pgadmin.org
обсуждение исходный текст
Ответы Re: BUG #1371: Short-circuit evaluation on PL/PgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Graham Robson"
Дата:
Сообщение: BUG #1372: Service won't start with tcpip_socket = true
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [pgsql-hackers-win32] More SSL questions..