| From: | hubert depesz lubaczewski <depesz(at)gmail(dot)com> |
|---|---|
| To: | alessandra de gregorio <adegregorio(at)fgscapital(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: serial number in output |
| Date: | 2005-10-28 14:41:33 |
| Message-ID: | 9e4684ce0510280741t3d86e7ccu7ac2664a6f7c3c3c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/28/05, alessandra de gregorio <adegregorio(at)fgscapital(dot)com> wrote:
>
> 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.
>
first of all - this is job for client program to do the numbering, but if
you really insist on having this in database (why?) then just use temporary
sequence.
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-10-28 14:47:38 | Re: [GENERAL] aix build question re: duplicate symbol warning |
| Previous Message | Douglas McNaught | 2005-10-28 14:39:22 | Re: Function written in C, hangs on one machine and not another... |