On Sun, Nov 28, 2010 at 7:44 PM, Yourfriend <doudou...@gmail.com> wrote: > In our company, we use both PostgreSQL and MySQL, our developers include me > think that the "INSERT ... ON DUPLICATE UPDATE " clause is a much more user > friendly function,so, would you please add this liked function in > PostgreSQL, I know we can write PROCEDURE or RULE to solve this problem,but > compare to write PROCEDURE or RULE, it's apparently more easy to add an > "INSERT... ON DUPLICATE" clause, so, please consider our request to make > PostgreSQL more power.
I hope very much we'll support something like this some day, but no one is working on it presently. There is, however, ongoing work to support SQL-standard MERGE. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers