Skip site navigation (1) Skip section navigation (2)

Re: MySQL Con 2008

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-advocacy(at)postgresql(dot)org, "Ron Mayer" <rm_pg(at)cheapcomplexdevices(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: MySQL Con 2008
Date: 2007-12-13 13:16:08
Message-ID: 36e682920712130516p41033705geb954705c93b3995@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Dec 13, 2007 12:56 AM, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
> > I think the "replace/upsert" feature
> > is one that some postgresql users ask for.
> >
>
> i think the only ones who do are mysql converts, given none of the other
> commercial db's offer that syntax (afaik).  note there are sql standard ways
> of accomplishing it; though currently neither of the two systems support it.

Huh?  We run into this all the time from non-MySQL people.  Oracle had
UPSERT and now Oracle, DB2, and SQL Server all support MERGE.

FWIW, I'd say it's a pretty big missing feature that can currently
only be worked around in a hackish PL sort of way.  I know Jan was
kicking around some ideas for it, but I don't know what happened after
that.


-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837                        | http://www.enterprisedb.com/

In response to

pgsql-advocacy by date

Next:From: Richard Broersma JrDate: 2007-12-13 18:26:45
Subject: Can SCALE 6x resurrect LAPUG
Previous:From: Robert TreatDate: 2007-12-13 05:56:07
Subject: Re: MySQL Con 2008

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group