pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Selecting 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