Re: Feature request: INSERT .... ON DUPLICATE UPDATE .... - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Feature request: INSERT .... ON DUPLICATE UPDATE ....
Date
Msg-id AANLkTimUvUejhXheiLJVhPewwOKVbQvaDTckVRkVotX2@mail.gmail.com
Whole thread Raw
In response to Feature request: INSERT .... ON DUPLICATE UPDATE ....  (Yourfriend <doudou586@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [GENERAL] column-level update privs + lock table
Next
From: Robert Haas
Date:
Subject: Re: contrib: auth_delay module