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
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 |
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) |