On Feb 2, 2012, at 0:32, tiplip <[email protected]> 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. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
