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 E010D925D42 for ; Thu, 29 May 2003 12:15:36 -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 98249-03 for ; Thu, 29 May 2003 12:15:35 -0400 (EDT) Received: from tao.office.aol.com (pix-fw.wan.aol.com [152.163.190.1]) by developer.postgresql.org (Postfix) with ESMTP id 7B716925D3B for ; Thu, 29 May 2003 12:15:33 -0400 (EDT) Received: from tao.office.aol.com (laotse@localhost [127.0.0.1]) by tao.office.aol.com (8.12.9/8.12.9/Debian-3) with ESMTP id h4TGBhV4006425 for ; Thu, 29 May 2003 12:11:43 -0400 Received: from localhost (laotse@localhost) by tao.office.aol.com (8.12.9/8.12.9/Debian-3) with ESMTP id h4TGBg0o006421 for ; Thu, 29 May 2003 12:11:42 -0400 X-Authentication-Warning: tao.office.aol.com: laotse owned process doing -bs Date: Thu, 29 May 2003 12:11:42 -0400 (EDT) From: Brian Knox X-X-Sender: laotse@tao.office.aol.com To: pgsql-sql@postgresql.org Subject: "record" datatype - plpgsql Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/550 X-Sequence-Number: 13715 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