Re: LIMIT modifier - Mailing list pgsql-general

From Troels Arvin
Subject Re: LIMIT modifier
Date
Msg-id pan.2003.12.15.19.12.32.128313@arvin.dk
Whole thread Raw
In response to LIMIT modifier  ("Roderick A. Anderson" <raanders@acm.org>)
List pgsql-general
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't have.

See also:
http://troels.arvin.dk/db/rdbms/#select-limit

--
Greetings from Troels Arvin, Copenhagen, Denmark


pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: LIMIT modifier
Next
From: Jenny Zhang
Date:
Subject: deadlock detected when inserting data