On 2004-06-18 20:15:11 UTC, Robert Treat wrote:
> IIRC the standard syntax is based on db2's horrendous merge on command,
> which was only added to the standard a couple months back.
Great! I didn't know that was standard.
I see that Oracle has it:
http://www.dba-oracle.com/oracle_tips_rittman_merge.htm
And db2 as you said:
http://www.databasejournal.com/features/db2/article.php/3322041
Could you explain why db2's merge command is horrendous?
Is it better the mysql command?
So will postgresql accept this command?
> IIRC the main downside to the select/update method is it introduces a
> race condition that can only be solved by locking the table; not an
> issue for most my$ql apps but would be frowned upon by most postgresql
> users.
Or course, if you don't need to do locking is a plus.
Eduardo