union and limit

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgres" <pgsql-general(at)postgresql(dot)org>
Subject: union and limit
Date: 2002-08-27 08:08:15
Message-ID: 004b01c24da0$e5636e00$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

i tried to send the following querry:

select * from table limit 3,0 UNION ALL select * from table limit 3,0;

This querry returned me an error so i put each select in parenthesis and it
worked.

Is this the way to solve it ?
if it is, i think it should be in the docs.

Cheer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mario Weilguni 2002-08-27 08:16:14 Re: union and limit
Previous Message Tom Lane 2002-08-27 05:35:46 Re: size of units in postgresql.conf