Horton

Re: Call for 7.5 feature completion

Ron Mayer <rm_pg@cheapcomplexdevices.com>

View thread
From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Harald Fuchs <hf0614x@protecting.net>
Date: 2005-08-29T20:03:35Z
Lists: pgsql-hackers 
Harald Fuchs wrote:
> In article <4312783F.4050603@familyhealth.com.au>,
> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>>
>>Oh, and 'select rowid, * from table' which returns special rowid
>>column that just incrementally numbers each row.
> 
> Why? 

Perhaps Christopher meant
    "select row_number() OVER (...) as rowid"
and then your "why" could be answered by
   "SQL Standard non-core feature T611"