Re: union and limit

"Ben-Nes Michael" <miki@canaan.co.il> writes:
> Is this the way to solve it ?
> if it is, i think it should be in the docs.

It is; read the SELECT man page:

select

     A select statement with all features except the ORDER BY, FOR
     UPDATE, and LIMIT clauses (even those can be used when the select
     is parenthesized).

            regards, tom lane