Re: Selecting columns by position?

From: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
To: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting columns by position?
Date: 2004-09-07 22:21:48
Message-ID: 4F86EA9F-011C-11D9-A3D4-000393779D9C@eku.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Well, a simple example, this is the ninth month,

I have some summaries that display monthly totals,
It would be nice if I could simply print columns
1-n if this is the nth month of the year and the total
for the year...

Jerry

On Sep 7, 2004, at 5:32 PM, Jeffrey Melloy wrote:

> Jerry LeVan wrote:
>
>> Hi,
>>
>> Is there any generic to select columns by position ie
>>
>> select the first, third, and fifth columns from ....
>>
>> I can't see anything in SQL...not to sure about
>> PL/PgSQL...
>>
>> Thanks
>>
>> Jerry
>
> No, not really. What kind of world do you live in where the position
> is more meaningful than the name?
>
> Jeff
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bender, Cheryl 2004-09-07 23:09:59 Alternate db location
Previous Message Jeffrey Melloy 2004-09-07 21:32:29 Re: Selecting columns by position?

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-07 22:22:35 Re: Firewall Security Requirements for Postgresql Access
Previous Message Gaetano Mendola 2004-09-07 22:14:04 Re: Firewall Security Requirements for Postgresql Access