Re: union and limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: "postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Re: union and limit
Date: 2002-08-27 13:32:48
Message-ID: 25658.1030455168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ben-Nes Michael" <miki(at)canaan(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-08-27 14:05:56 Re: size of units in postgresql.conf
Previous Message Jerome Chochon 2002-08-27 13:23:06 Inherits Triggers or Rules