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 34E66925F48 for ; Thu, 29 May 2003 18:05:27 -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 92226-06 for ; Thu, 29 May 2003 18:05:15 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by developer.postgresql.org (Postfix) with ESMTP id 9A698925F26 for ; Thu, 29 May 2003 18:05:09 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B7D53D60C; Thu, 29 May 2003 15:05:01 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 852AE5C0D; Thu, 29 May 2003 15:05:01 -0700 (PDT) Date: Thu, 29 May 2003 15:05:01 -0700 (PDT) From: Stephan Szabo To: Brian Knox Cc: Subject: Re: "record" datatype - plpgsql In-Reply-To: Message-ID: <20030529150416.K65610-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/561 X-Sequence-Number: 13726 On Thu, 29 May 2003, Brian Knox wrote: > 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? AFAIK there isn't one without other information (like that the table was "foo").