Postgres Pro
Downloads
Home   >   mailing lists

serial number in output - Mailing list pgsql-general

From alessandra de gregorio
Subject serial number in output
Date
Msg-id 20051028134212.72DBCDB212@svr1.postgresql.org
Whole thread Raw
Responses Re: serial number in output  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Troy"
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: "Troy"
Date:
Subject: tablename.columnname%TYPE in Functions & Types