David Johnston wrote
>
>
> Window function
>
> Row_number() over ()
>
> David J.
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
Thanks, David
It really works.
--
View this message in con
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
Hi all,
I have a couple of tables with same structure but standing for different
layers(1,2,3...) respectivle for Mapserver,
table1
gid| id| name | address| post code | layer
| geom
---+--+--+-+---++
