From: David Johnston <polobo@yahoo.com>
To: tiplip <chengwei02@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Multiple tables query on Mapserver
Date: Thu, 2 Feb 2012 00:45:20 -0500
Message-ID: <682658F3-609B-40D1-B9ED-B105F92FD583@yahoo.com> (raw)
In-Reply-To: <1328160724935-5449662.post@n5.nabble.com>
References: <1328159813393-5449642.post@n5.nabble.com>
<59D2E8F6-962D-4DDC-96C0-5985AE0F4D9A@yahoo.com>
<1328160724935-5449662.post@n5.nabble.com>
On Feb 2, 2012, at 0:32, tiplip <chengwei02@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: polobo@yahoo.com, chengwei02@gmail.com
Subject: Re: Multiple tables query on Mapserver
In-Reply-To: <682658F3-609B-40D1-B9ED-B105F92FD583@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox