|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 4th, 2003, 01:46 AM
|
|||
|
|||
|
postgres sequence
I have to do select statement but I wish to add another column which print out sequence number for each row.
Item Data 1 mydata1 2 hel 3 h 4 h 5 s 6 s
|
|
#2
August 4th, 2003, 10:31 AM
|
|||
|
|||
|
Just create a temporary sequence, and drop it when you are done. (or, you can just leave it, and expect it to be dropped automatically when you finish the current database session).
Code:
CREATE TEMPORARY SEQUENCE tempcounter START 1;
SELECT nextval('tempcounter') as counter, mycolumn FROM mytable;
DROP sequence tempcounter;
Since temporary sequences (like temporary tables) are private to the session user, it doesn't matter if the same piece of code is being run by many different users, because they will each be only accessing their own 'tempcounter' sequence.
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com
|
|
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > postgres sequence |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
