"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
