Re: Getting a random row

On Oct 13, 2009, at 11:19 , Grzegorz Jaśkiewicz wrote:

> On Tue, Oct 13, 2009 at 4:17 PM, Shaul Dar <shauldar@gmail.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