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