pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSelecting columns by position?
3+ messages / 2 participants
[nested] [flat]
* Selecting columns by position?
@ 2004-09-07 15:42 Jerry LeVan <jerry.levan@eku.edu>
2004-09-07 21:32 ` Re: Selecting columns by position? Jeffrey Melloy <jmelloy@visualdistortion.org>
0 siblings, 1 reply; 3+ messages in thread
From: Jerry LeVan @ 2004-09-07 15:42 UTC (permalink / raw)
To: Postgres General <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Selecting columns by position?
2004-09-07 15:42 Selecting columns by position? Jerry LeVan <jerry.levan@eku.edu>
@ 2004-09-07 21:32 ` Jeffrey Melloy <jmelloy@visualdistortion.org>
2004-09-07 22:21 ` Re: Selecting columns by position? Jerry LeVan <jerry.levan@eku.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Jeffrey Melloy @ 2004-09-07 21:32 UTC (permalink / raw)
To: Jerry LeVan <jerry.levan@eku.edu>; +Cc: Postgres General <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Selecting columns by position?
2004-09-07 15:42 Selecting columns by position? Jerry LeVan <jerry.levan@eku.edu>
2004-09-07 21:32 ` Re: Selecting columns by position? Jeffrey Melloy <jmelloy@visualdistortion.org>
@ 2004-09-07 22:21 ` Jerry LeVan <jerry.levan@eku.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Jerry LeVan @ 2004-09-07 22:21 UTC (permalink / raw)
To: Jeffrey Melloy <jmelloy@visualdistortion.org>; +Cc: Postgres General <pgsql-general@postgresql.org>
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-09-07 22:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-07 15:42 Selecting columns by position? Jerry LeVan <jerry.levan@eku.edu>
2004-09-07 21:32 ` Jeffrey Melloy <jmelloy@visualdistortion.org>
2004-09-07 22:21 ` Jerry LeVan <jerry.levan@eku.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox