> -Original Message-
> From: John Fabiani [mailto:[email protected]]
> Sent: Monday, June 11, 2012 11:11 AM
> To: Igor Neyman
> Cc: [email protected]
> Subject: Re: using ordinal_position
>
> On 06/11/2012 06:53 AM, Igor Neyman wrote:
> >
> >> -Original Message-
> >> Fr
On 06/11/2012 06:53 AM, Igor Neyman wrote:
-Original Message-
From: John Fabiani [mailto:[email protected]]
Sent: Thursday, June 07, 2012 7:18 PM
To: [email protected]
Subject: using ordinal_position
I'm attempting to retrieve data using a select statement without
knowing the
> -Original Message-
> From: John Fabiani [mailto:[email protected]]
> Sent: Thursday, June 07, 2012 7:18 PM
> To: [email protected]
> Subject: using ordinal_position
>
> I'm attempting to retrieve data using a select statement without
> knowing the column names. I know the ord
> -Original Message-
> From: [email protected] [mailto:pgsql-sql-
> [email protected]] On Behalf Of John Fabiani
> Sent: Thursday, June 07, 2012 7:18 PM
> To: [email protected]
> Subject: [SQL] using ordinal_position
>
> I'm attemp
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
