Re: UNION & LIMIT & ORDER BY

From: Guillaume LELARGE <gleu(at)wanadoo(dot)fr>
To: emmanuel(at)engelhart(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: UNION & LIMIT & ORDER BY
Date: 2003-06-16 19:37:36
Message-ID: 200306161937.36395.gleu@wanadoo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/ -->.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bu, Ning 2003-06-16 22:02:34 set decimal point in SQL
Previous Message Tom Lane 2003-06-16 19:02:38 Re: casting interval to time