Re: "record" datatype - plpgsql

Hi Brian;

Assuming "NEW" has been declared as   foo%rowtype,  you can access the
columns thus
   NEW.xxx where xxx is the column name

HTH.
George

----- Original Message -----
From: "Brian Knox" <laotse@aol.net>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, May 29, 2003 11:11 AM
Subject: [SQL] "record" datatype - plpgsql


> Given a variable of the "record" data type in pl/pgsql, is it possible to
> get the names of the columns ( attributes ) of that record?
>
> eg, given record "NEW" for table "foo", is there a way to get information
> concerning the columns that make up that record?
>
> Brian Knox
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>