using ordinal_position

Поиск
Список
Период
Сортировка
Искать
От
John Fabiani
Тема
using ordinal_position
Дата
Msg-id
4FD1368E.5000304@jfcomputer.com
Список
Дерево обсуждения
using ordinal_position John Fabiani <johnf@jfcomputer.com>
Re: using ordinal_position "David Johnston" <polobo@yahoo.com>
Re: using ordinal_position Igor Neyman <ineyman@perceptron.com>
Re: using ordinal_position John Fabiani <johnf@jfcomputer.com>
Re: using ordinal_position Igor Neyman <ineyman@perceptron.com>
I'm attempting to retrieve data using a select statement without knowing 
the column names. I know the ordinal position but not the name of the 
column (happens to be a date::text and I have 13 fields).

Below provides the name of the column in position 3:

select column_name from (select column_name::text, ordinal_position from 
information_schema.columns where
table_name='wk_test') as foo where ordinal_position = 3;

But how can I use the above as a column name in a normal select statement.

Unlike other databases I just can't use ordinal position in the select 
statement - RIGHT???

Johnf

В списке pgsql-sql по дате отправления
От: David Johnston
Дата:
Сообщение: Re: defaults in a function
От: David Johnston
Дата:
Сообщение: Re: using ordinal_position
FAQ