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 02A21925E76 for ; Thu, 29 May 2003 16:50:47 -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 70710-06 for ; Thu, 29 May 2003 16:50:46 -0400 (EDT) Received: from smtp1.mts.net (smtp1.mts.net [205.200.16.74]) by developer.postgresql.org (Postfix) with ESMTP id 02F80925E46 for ; Thu, 29 May 2003 16:50:46 -0400 (EDT) Received: from cleartag (wnpgmb01bbz-ac04-p13-24.mts.net [142.161.13.24]) by smtp1.mts.net (8.12.8p1/8.11.3) with SMTP id h4TKofGl018734; Thu, 29 May 2003 15:50:42 -0500 (CDT) Message-ID: <005001c32624$0f0f3980$0100007f@cleartag> From: "George Weaver" To: "Brian Knox" , References: Subject: Re: "record" datatype - plpgsql Date: Thu, 29 May 2003 14:01:54 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/559 X-Sequence-Number: 13724 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" To: 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 >