LIMIT modifier - Mailing list pgsql-general

From Roderick A. Anderson
Subject LIMIT modifier
Date
Msg-id Pine.LNX.4.33.0312150927440.26835-100000@main.cyber-office.net
Whole thread Raw
Responses Re: LIMIT modifier  (Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>)
List pgsql-general
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
--
    "Open Source Software - You usually get more than you pay for..."
     "Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"



pgsql-general by date:

Previous
From: Nathaniel Price
Date:
Subject: Re: Reordering results for a report (follow-up)
Next
From: Arjen van der Meijden
Date:
Subject: Re: LIMIT modifier