how can i make use of the column number instead of the column name when making the select statement?
"SELECT mytable.col, mytable.col, mytable.col, 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 different tables 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
|Next:||From: Michael Fuhr||Date: 2006-01-21 05:22:46|
|Subject: Re: column number instead of column name|
|Previous:||From: Lynna Landstreet||Date: 2006-01-20 07:36:27|
|Subject: Re: Problems with select statement|