X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CC45329DC4 for ; Wed, 8 Sep 2004 01:49:26 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40830-05 for ; Wed, 8 Sep 2004 00:49:18 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 3C33F329EEC for ; Wed, 8 Sep 2004 01:49:03 +0100 (BST) Received: from calvin.slamb.org (calvin.slamb.org [216.136.66.56]) by www.postgresql.com (Postfix) with ESMTP id 773A35A1175 for ; Tue, 7 Sep 2004 22:32:58 +0100 (BST) Received: by calvin.slamb.org (Postfix, from userid 103) id 3CA6D6FCFF; Tue, 7 Sep 2004 16:32:32 -0500 (CDT) Received: from [129.255.38.180] (host38-180.hc-dhcp.uiowa.edu [129.255.38.180]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by calvin.slamb.org (Postfix) with ESMTP id 4345C6FCD3; Tue, 7 Sep 2004 16:32:30 -0500 (CDT) Message-ID: <413E28ED.2000505@visualdistortion.org> Date: Tue, 07 Sep 2004 16:32:29 -0500 From: Jeffrey Melloy User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jerry LeVan Cc: Postgres General Subject: Re: Selecting columns by position? References: <95CEE0C2-00E4-11D9-A3D4-000393779D9C@eku.edu> In-Reply-To: <95CEE0C2-00E4-11D9-A3D4-000393779D9C@eku.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/295 X-Sequence-Number: 65501 Jerry LeVan wrote: > Hi, > > Is there any generic to select columns by position ie > > select the first, third, and fifth columns from .... > > I can't see anything in SQL...not to sure about > PL/PgSQL... > > Thanks > > Jerry No, not really. What kind of world do you live in where the position is more meaningful than the name? Jeff