Thread: serial in output
Hi, What function should I use to get a serial number, together with my results, from a query? Ex. Of output I want: 1 ooo pp ij 2 hou joo iu 3 bhi ft yh Basically, I would like to have one column with integers, from 1 onwards, no matter how many tables I join in, or the data that I get back. Thanks
alessandra de gregorio <adegregorio@fgscapital.com> schrieb: > Hi, > > What function should I use to get a serial number, together with my results, > from a query? > > Ex. Of output I want: > > 1 ooo pp ij > 2 hou joo iu > 3 bhi ft yh > > Basically, I would like to have one column with integers, from 1 onwards, no > matter how many tables I join in, or the data that I get back. Create a sequence and then "select nextval('your_sequence'), * from foo;" HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
In article <20051028111824.C8C7DDA53F@svr1.postgresql.org>, "alessandra de gregorio" <adegregorio@fgscapital.com> writes: > Hi, > What function should I use to get a serial number, together with my results, > from a query? > Ex. Of output I want: > 1 ooo pp ij > 2 hou joo iu > 3 bhi ft yh > Basically, I would like to have one column with integers, from 1 onwards, no > matter how many tables I join in, or the data that I get back. I'd do it in application code, but if you insist on doing it at the SQL layer: CREATE TEMPORARY SEQUENCE tmpseq; SELECT nextval('tmpseq'), othercols... FROM ...