Re: Feature request: INSERT .... ON DUPLICATE UPDATE ....

On Sun, Nov 28, 2010 at 7:44 PM, Yourfriend <doudou586(at)gmail(dot)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