Re: Multiple tables query on Mapserver

From: David Johnston <polobo(at)yahoo(dot)com>
To: tiplip <chengwei02(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Multiple tables query on Mapserver
Date: 2012-02-02 05:45:20
Message-ID: 682658F3-609B-40D1-B9ED-B105F92FD583@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Feb 2, 2012, at 0:32, tiplip <chengwei02(at)gmail(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tiplip 2012-02-02 07:58:35 Re: Multiple tables query on Mapserver
Previous Message tiplip 2012-02-02 05:32:04 Re: Multiple tables query on Mapserver