Re: LIMIT modifier

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. Anderson wrote:

> I'm dealing with a project that requires me to query a MS SQL Server.  Not
> a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL
> standard?  MS SQL Server uses a TOP modifier.
>
>     select top 1 * from xxx;
>
> Whereas all the SQL RDBMS' I've used before used
>
>     select * from xxx limit 1;
>
> Any enlightenment is appreciated. (I'm putting notes in the code to
> reflect the non-standard stuff I've had to deal with.)
>
>
> TIA,
> Rod