Re: LIMIT modifier

From: Troels Arvin <troels(at)arvin(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: LIMIT modifier
Date: 2003-12-15 19:12:32
Message-ID: pan.2003.12.15.19.12.32.128313@arvin.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jenny Zhang 2003-12-15 19:52:11 deadlock detected when inserting data
Previous Message Roderick A. Anderson 2003-12-15 18:51:56 Re: LIMIT modifier