Re: INSERT OR UPDATE?

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, David Fetter <david(at)fetter(dot)org>, Jerry Sievers <jerry(at)jerrysievers(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: INSERT OR UPDATE?
Date: 2005-10-10 23:48:10
Message-ID: 20051010234810.GG39569@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Check the TODO, I'm 99% certain it's on there.

On Mon, Oct 10, 2005 at 02:02:32PM +0200, Csaba Nagy wrote:
> On Mon, 2005-10-10 at 13:34, Lincoln Yeoh wrote:
> [snip]
> > It's actually quite surprising how many people get this wrong and don't
> > realize it (I wonder how many problems are because of this). The SQL spec
> > should have had a PUT/MERGE decades ago. The insert vs update format being
> > different is also annoying, oh well.
>
> Referring to the above, is there any plan to implement such commands in
> postgres ? I don't know if it is standard SQL, but some other RDBMSes
> have such command, and they are actually useful.
>
> >
> > Regards,
> > Link.
> [snip]
>
> Cheers,
> Csaba.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-10-10 23:50:33 Re: How to inject knowledge into a Postgres database
Previous Message Jim C. Nasby 2005-10-10 23:41:42 Re: Oracle buys Innobase