Обсуждение: Feature request: INSERT .... ON DUPLICATE UPDATE ....

Dear all, <br /><br />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
functionin 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
PostgreSQLmore power. <br /><br />Thanks all for great work to PostgreSQL.<br /><br />Daojing.Zhou <br />2010/11/29<br
/>

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