Re: union and limit

select * from (select * from table limit 3,0) as foo1
UNION ALL
select * (select * from table limit 3,0) as foo2

might work, but I did not try

----- Original Message -----
From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgres" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, August 27, 2002 10:08 AM
Subject: [GENERAL] union and limit

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>