Received: from ford.core.rockstorm.se (aurorum77-0.aurorum.se [213.88.249.77])
	by postgresql.org (Postfix) with ESMTP id 43CAD47590F
	for <pgsql-sql@postgresql.org>; Fri,  5 Apr 2002 09:08:31 -0500 (EST)
Received: (from dot@localhost)
	by ford.core.rockstorm.se (8.11.0/8.11.0) id g35E8Xl00925
	for pgsql-sql@postgresql.org; Fri, 5 Apr 2002 16:08:33 +0200 (CEST)
Date: Fri, 5 Apr 2002 16:08:33 +0200
From: Magnus Enbom <dot@rockstorm.se>
To: pgsql-sql@postgresql.org
Subject: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Message-ID: <20020405160833.A917@ford.rockstorm.se>
Reply-To: magnus.enbom@rockstorm.se
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
X-Archive-Number: 200204/65
X-Sequence-Number: 7330

Hi,

I've just been hit by a small but annoying difference between postgres(7.2)
and mysql(4.x).
In postgresql you do:

SELECT * FROM table FOR UPDATE LIMIT 1;

and in mysql you do:

SELECT * FROM table LIMIT 1 FOR UPDATE;

Is it possible for postgres to accept the mysql syntax as well?
It's not that many databases that implement LIMIT, so it would be nice if the
ones that do have the same syntax(or can accept each others variants).

-- Magnus