| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-12-13 18:26:45 | Can SCALE 6x resurrect LAPUG |
| Previous Message | Robert Treat | 2007-12-13 05:56:07 | Re: MySQL Con 2008 |