column number instead of column name - Mailing list pgsql-novice

From First Last
Subject column number instead of column name
Date
Msg-id 20060120002437.E662DAB0@dm20.mta.everyone.net
Whole thread Raw
Responses Re: column number instead of column name
List pgsql-novice
how can i make use of the column number instead of the column name when making the select statement?

for instance:
"SELECT mytable.col[1], mytable.col[2], mytable.col[3], mytable.userid from mytable"

i have several tables and i need to extract the first three columns and a known column. the first three columns for the
differenttables vary, but all the tables have the userid column. 


_____________________________________________________________
Check out Atenista.Net (www.atenista.net)- new design, regular content and additional services!

pgsql-novice by date:

Previous
From: Lynna Landstreet
Date:
Subject: Re: Problems with select statement
Next
From: Michael Fuhr
Date:
Subject: Re: column number instead of column name