LIMIT modifier - Mailing 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"