Selecting columns by position?

From: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Selecting columns by position?
Date: 2004-09-07 15:42:55
Message-ID: 95CEE0C2-00E4-11D9-A3D4-000393779D9C@eku.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Worth Bishop 2004-09-07 18:27:36 Recover from data corruption?
Previous Message Tom Lane 2004-09-07 14:16:28 Re: [PERFORM] TOAST tables, cannot truncate

Browse pgsql-general by date

  From Date Subject
Next Message Tore Halset 2004-09-07 16:08:35 Re: ERROR: canceling query due to user request
Previous Message Oliver Elphick 2004-09-07 15:41:30 Re: restricting non superuser from accessing other