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