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(at)aol(dot)net>
To: <pgsql-sql(at)postgresql(dot)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
>