Re: UNION & LIMIT & ORDER BY - Mailing list pgsql-sql

From Guillaume LELARGE
Subject Re: UNION & LIMIT & ORDER BY
Date
Msg-id 200306161937.36395.gleu@wanadoo.fr
Whole thread Raw
In response to UNION & LIMIT & ORDER BY  (Emmanuel Engelhart <emmanuel@engelhart.org>)
List pgsql-sql
Hi,

Le Samedi 14 Juin 2003 17:01, Emmanuel Engelhart a écrit :
> [...]
Taken from the postgresql manual
(http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-select.html#SQL-UNION):
ORDER BY and LIMIT can be attached to a sub-expression if it is enclosed in
parentheses. Without parentheses, these clauses will be taken to apply to the
result of the UNION, not to its right-hand input expression.


Regards.


--
Guillaume <!-- http://absfr.tuxfamily.org/ -->.


pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: "No such attribute or function 'oid'"
Next
From: Tom Lane
Date:
Subject: Re: casting interval to time