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. > -- > Sent via pgsql-sql mailing list (pgsql-sql@) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- View this message in context: http://postgresql.1045698.n5.nabble.com/Multiple-tables-query-on-Mapserver-tp5449642p5449662.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql