Re: union and limit

On Tue, 27 Aug 2002, Ben-Nes Michael wrote:

> 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.


If you read carefully the syntax for the SELECT from

    http://developer.postgresql.org/docs/postgres/sql-select.html

you will see that the limit clause in the first select is not allowed
there. Don't forget the LIMIT applies to the entire result set not the last
select making up the union.

So in short, that is how it's supposed to work so there's no need to document
it.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants