On Mon, 15 Dec 2003 09:32:34 -0800, Roderick A. Anderson wrote:
> want to ask if the LIMIT modifier is SQL standard?
No. The standard doesn't have anything like that, unfortunately.
> MS SQL Server uses a TOP modifier.
Yes, but it accepts an optional "WITH TIES" modifier which PostgreSQL
doesn'
On Mon, 15 Dec 2003, Arjen van der Meijden wrote:
> "Nonstandard Clauses
>
> The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
> standard."
Humm. Is there a SQL standard to return a subset of the selected tuples?
This being contrary to relational theory I believe. :-)
>
Rod,
Have a look at the bottom of this page:
http://www.postgresql.org/docs/current/static/sql-select.html
"Nonstandard Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
standard."
TOP x isn't in the standard as well, afaik.
Best regards,
Arjen
Roderick A. Anderso
