On Oct 13, 2009, at 11:19 , Grzegorz Jaśkiewicz wrote:
On Tue, Oct 13, 2009 at 4:17 PM, Shaul Dar <shauldar@xxxxxxxxx> wrote:
Also PG does not have a concept of an auto-increment pseudo-column
like
Oracle's "rownum". Any suggestions?
not true - it has sequences, and pseudo type serial. Rtfm!.
AIUI, rownum applies numbering to output rows in a SELECT statement,
rather than some actual column of the table, which is likely what the
OP is getting at.
http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html
Michael Glaesemann
grzm seespotcode net
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
