> -Original Message-
> From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-
> ow...@postgresql.org] On Behalf Of John Fabiani
> Sent: Thursday, June 07, 2012 7:18 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] using ordinal_position
>
> I'm attempting to retrieve data using a select
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_n
