469,112 Members | 2,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,112 developers. It's quick & easy.

Selecting columns by position?

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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1
2 1185
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Axial | last post: by
6 posts views Thread by aaj | last post: by
1 post views Thread by Xh | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.