LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

From: Magnus Enbom <dot(at)rockstorm(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date: 2002-04-05 14:08:33
Message-ID: 20020405160833.A917@ford.rockstorm.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2002-04-05 15:04:09 Re: timeout implementation issues
Previous Message Bruce Momjian 2002-04-05 11:39:44 Re: Always the same ecpg bug - please (re)apply patch

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Adler 2002-04-05 14:28:51 Re: FULL JOIN with 3 or more tables
Previous Message Frank Joerdens 2002-04-05 10:08:51 Re: Rule trouble (looks to me exactly like the example)