Re: Getting a random row

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Michael,

You are right. I didn't remember the semantics, and Oracle's rownum would not have been helpful. But the new row_number() in 8.4 would probably do the trick (though I use 8.3.7 :-( )

-- Shaul

2009/10/13 Michael Glaesemann <grzm@xxxxxxxxxxxxxxx>

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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux