Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E82449FB554 for ; Mon, 22 Jan 2007 18:56:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 25827-04 for ; Mon, 22 Jan 2007 18:56:06 -0400 (AST) X-Greylist: delayed 00:30:44.218043 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 910349FB4F1 for ; Mon, 22 Jan 2007 18:56:06 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from itspmx2.state.ms.us (itspmx2.state.ms.us [205.144.224.112]) by svr4.postgresql.org (Postfix) with ESMTP id 737DA5AF988 for ; Mon, 22 Jan 2007 22:25:21 +0000 (GMT) Received: from rray.drdc.mstc.ms.gov ([10.3.192.2]) by itspmx2.state.ms.us (8.13.4/8.13.4) with ESMTP id l0MMP8jj022042 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 22 Jan 2007 16:25:14 -0600 (CST) Received: from rray.drdc.mstc.ms.gov (localhost.localdomain [127.0.0.1]) by rray.drdc.mstc.ms.gov (8.13.8/8.13.6) with ESMTP id l0MMP8qU005792 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 22 Jan 2007 16:25:08 -0600 Received: from localhost (rray@localhost) by rray.drdc.mstc.ms.gov (8.13.8/8.13.8/Submit) with ESMTP id l0MMP8lY005789 for ; Mon, 22 Jan 2007 16:25:08 -0600 X-Authentication-Warning: rray.drdc.mstc.ms.gov: rray owned process doing -bs Date: Mon, 22 Jan 2007 16:25:08 -0600 (CST) From: Richard Ray X-X-Sender: rray@rray.drdc.mstc.ms.gov To: pgsql-sql@postgresql.org Subject: How to query by column names Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/102 X-Sequence-Number: 27254 This may be a simple but can I create a query such as select (select attname from pg_attribute where attrelid = (select relfilenode from pg_class where relname = 't1') and attisdropped = false and attnum > 0) from t1; I get ERROR: more than one row returned by a subquery used as an expression Thanks Richard