X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 7B2A4924D12
	for <pgsql-sql@postgresql.org>; Fri, 30 May 2003 09:50:32 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 00486-03 for <pgsql-sql@postgresql.org>;
	Fri, 30 May 2003 09:50:30 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by developer.postgresql.org (Postfix) with ESMTP id 69173924B47
	for <pgsql-sql@postgresql.org>; Fri, 30 May 2003 09:50:28 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4UDo2U6009213;
	Fri, 30 May 2003 09:50:02 -0400 (EDT)
To: Brian Knox <laotse@aol.net>
Cc: George Weaver <georgew1@mts.net>, pgsql-sql@postgresql.org
Subject: Re: "record" datatype - plpgsql 
In-reply-to: <Pine.LNX.4.53.0305300851380.13440@tao.office.aol.com> 
References: <Pine.LNX.4.53.0305280753040.30365@tao.office.aol.com>
	<005001c32624$0f0f3980$0100007f@cleartag>
	<Pine.LNX.4.53.0305300851380.13440@tao.office.aol.com>
Comments: In-reply-to Brian Knox <laotse@aol.net>
	message dated "Fri, 30 May 2003 08:52:09 -0400"
Date: Fri, 30 May 2003 09:50:02 -0400
Message-ID: <9212.1054302602@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/566
X-Sequence-Number: 13731

Brian Knox <laotse@aol.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