Postgres Pro
Downloads
Home   >   mailing lists

Re: RECORD.* doesn't work in Pl/PGSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RECORD.* doesn't work in Pl/PGSQL
Date
Msg-id 27637.1208900484@sss.pgh.pa.us
Whole thread Raw
In response to RECORD.* doesn't work in Pl/PGSQL  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
Tree view 
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> RECORD.* doesn't work in plpgsql, but NEW.* and OLD.* do in trigger
> functions created in plpgsql.

NEW and OLD have predetermined column sets (within any one trigger function).
A RECORD variable doesn't.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: WIP: psql default banner patch
Next
From: Alvaro Herrera
Date:
Subject: Re: WIP: psql default banner patch