Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D2B591E8B8EA for ; Thu, 2 Feb 2012 01:45:38 -0400 (AST) Received: from nm2-vm1.bullet.mail.ne1.yahoo.com ([98.138.91.33]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1RspUG-0002OR-4l for pgsql-sql@postgresql.org; Thu, 02 Feb 2012 05:45:38 +0000 Received: from [98.138.90.52] by nm2.bullet.mail.ne1.yahoo.com with NNFMP; 02 Feb 2012 05:45:21 -0000 Received: from [98.138.87.3] by tm5.bullet.mail.ne1.yahoo.com with NNFMP; 02 Feb 2012 05:45:21 -0000 Received: from [127.0.0.1] by omp1003.mail.ne1.yahoo.com with NNFMP; 02 Feb 2012 05:45:21 -0000 X-Yahoo-Newman-Id: 933082.48813.bm@omp1003.mail.ne1.yahoo.com Received: (qmail 34770 invoked from network); 2 Feb 2012 05:45:21 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Transfer-Encoding:Content-Type:Message-Id:Cc:X-Mailer:From:Subject:Date:To; b=mSDBTJS0uGDNB+IN2tIc0SvqonJRTxkFynDwPpm0LHXG5Q99X6DgOt+C6uQNjKygNqlVjYhDhzfYz7ZkKjBvv8ULXw9vdEanX76O2YYF3KoodtgRiKEPgllx+oBc5wDl7I49DUYEWjryUC9LV7fEZmz2J9Xf8w19llPUoP9GBEw= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1328161521; bh=xfCkT4bi1m8AHsue+qh5rzaVKGEwpyOGX7/5wZ+rb4E=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Transfer-Encoding:Content-Type:Message-Id:Cc:X-Mailer:From:Subject:Date:To; b=NiZvei6z8u/6UVLld4GFwuzYQFQBxRm8EHRavHZjM/FRg7aW8syjHSXvsZfyZOJ3YNEqjMruUdKyeAQ3cxUOPK+hux0h6fDnDhJnMZwLxZoh6SqyL6A+ihNLfsKuYftGc1Ps8q2384dI14IDn3TEw5qAvLyiaIJ/4hLd5QHkCj8= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: hWiNA5EVM1mb9Qik7CsRbC5NWGNmXY0A5zg2oclVtup4YjK HOvnsstMopPHQbPXOzMr3x4GnqpQ6OKbzPqJR308qavvktECtIIbwQDpx1rw fj8xVG.puWMwqt0hYIaCJ3Wt4zVKbEJWUA5yPbGdygB5kdYS6xtk_vZeHINy aasz_uTclFWJENl7kN7E9wFGj.aMQtuEihd4rwpt_mM9mfXi1EDdK5SaSsp. jJf_NDm0sGwkYOdOn4nj3PMnMIxVltlryXnDQnvFz6mN9xOrooqqus0mMG9o hUHyZfhX2ybd5j_n2jIif8fUZs3_wqtPSEirAyDb6Nvut.GYh2ZN6vdgjBgT D_4ht738_NMNUZm59jFT1Iu68kgVAw46g2JpVOdslRiDDQUa0rtjcL6dfS2a UlspNjitiXPRfCnt5ZNpE X-Yahoo-SMTP: mpGJl6eswBD2IBufoVEg0Pa8gg-- Received: from [192.12.17.102] (polobo@24.93.23.188 with xymcookie) by smtp109-mob.biz.mail.ne1.yahoo.com with SMTP; 01 Feb 2012 21:45:21 -0800 PST References: <1328159813393-5449642.post@n5.nabble.com> <59D2E8F6-962D-4DDC-96C0-5985AE0F4D9A@yahoo.com> <1328160724935-5449662.post@n5.nabble.com> In-Reply-To: <1328160724935-5449662.post@n5.nabble.com> Mime-Version: 1.0 (1.0) Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Message-Id: <682658F3-609B-40D1-B9ED-B105F92FD583@yahoo.com> Cc: "pgsql-sql@postgresql.org" X-Mailer: iPad Mail (9A405) From: David Johnston Subject: Re: Multiple tables query on Mapserver Date: Thu, 2 Feb 2012 00:45:20 -0500 To: tiplip X-Pg-Spam-Score: -2.0 (--) X-Archive-Number: 201202/7 X-Sequence-Number: 36300 On Feb 2, 2012, at 0:32, tiplip wrote: > I just need gid or id in increasing order start from 0 (or 1), fetching th= eir > original gid (or id) value is not necessary:) > can I do that? >=20 >=20 > David Johnston wrote >>=20 >>=20 >> The general method is to use "UNION" but not sure about the changing of >> the gid and id values... >>=20 >> David J. >> --=20 >>=20 Window function Row_number() over () David J.