union and limit - Mailing list pgsql-general

From Ben-Nes Michael
Subject union and limit
Date
Msg-id 004b01c24da0$e5636e00$aa0f5ac2@canaan.co.il
Whole thread Raw
Responses Re: union and limit  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: union and limit  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: size of units in postgresql.conf
Next
From: "Mario Weilguni"
Date:
Subject: Re: union and limit