documentation bug - behave of NEW a OLD in plpgsql's triggers

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: documentation bug - behave of NEW a OLD in plpgsql's triggers
Date: 2011-05-02 16:00:48
Message-ID: BANLkTi=Neok1uboh4P4jxuGWBpbOFH2wdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

Hello

one czech user reported a bug in documentation -
http://www.postgresql.org/docs/8.4/static/plpgsql-trigger.html

NEW

Data type RECORD; variable holding the new database row for
INSERT/UPDATE operations in row-level triggers. This variable is NULL
in statement-level triggers and for DELETE operations.
OLD

Data type RECORD; variable holding the old database row for
UPDATE/DELETE operations in row-level triggers. This variable is NULL
in statement-level triggers and for INSERT operations.

It isn't correct. NEW is not declared in DELETE trigger, OLD isn't
declared in INSERT

Regards

Pavel Stehule

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Savita 2011-05-02 16:33:51 BUG #6002: French character show garbled
Previous Message hubert depesz lubaczewski 2011-05-02 10:45:14 Re: BUG #6001: date_trunc is not timezone aware

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2011-05-02 16:47:01 Re: Documentation tweaks: ALTER USER, statement-based middleware
Previous Message Josh Kupershmidt 2011-05-01 23:07:10 Re: boolean states