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
On Feb 2, 2012, at 0:32, tiplip 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
>
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
On Feb 2, 2012, at 0:16, tiplip wrote:
> 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
> ---+--+---
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
---+--+--+-+---++
