On Oct 13, 2009, at 11:19 , Grzegorz Jaśkiewicz wrote:
> On Tue, Oct 13, 2009 at 4:17 PM, Shaul Dar <shauldar(at)gmail(dot)com> 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