Feature request: INSERT .... ON DUPLICATE UPDATE ....
Dear all,
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.
Thanks all for great work to PostgreSQL.
Daojing.Zhou
2010/11/29
On Sun, Nov 28, 2010 at 7:44 PM, Yourfriend <doudou586@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