Re: "record" datatype - plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Knox <laotse(at)aol(dot)net>
Cc: George Weaver <georgew1(at)mts(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: "record" datatype - plpgsql
Date: 2003-05-30 13:50:02
Message-ID: 9212.1054302602@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Brian Knox <laotse(at)aol(dot)net> writes:
> What I was asking is if there's anyway to use
> the NEW record to get a list of the columnnames in it without knowing them
> beforehand.

Not in plpgsql ... and if you did, you couldn't do anything useful with
the names (like access the fields) anyway. I believe you can do it in
pltcl though.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jr. 2003-05-30 14:38:36 Re: "record" datatype - plpgsql
Previous Message Brian Knox 2003-05-30 12:52:09 Re: "record" datatype - plpgsql