Re: Getting a random row

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(at)seespotcode(dot)net>

>
> 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
>
>
>
>