On Feb 2, 2012, at 0:32, tiplip <chengwei02@gmail.com> wrote:
> I just need gid or id in increasing order start from 0 (or 1), fetching their
> original gid (or id) value is not necessary:)
> can I do that?
>
>
> David Johnston wrote
>>
>>
>> The general method is to use "UNION" but not sure about the changing of
>> the gid and id values...
>>
>> David J.
>> --
>>
Window function
Row_number() over ()
David J.