Postgres Pro
Downloads
Home   >   mailing lists

Re: "on existing update" construct - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: "on existing update" construct
Date
Msg-id CAAZKuFby5R4PrdnKLqcmLPbMJsjgPuFzOcgCcSa2ER0j7jsWDw@mail.gmail.com
Whole thread Raw
In response to "on existing update" construct  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: "on existing update" construct  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, May 15, 2013 at 11:44 AM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
> Hello,
>
> Is there an alternative of Sybase "on existing update" construct in pgsql.
>
> "ON DUPLICATE KEY UPDATE" doesn't work.
>
> Thanks in advance!

No, you'll have to either handle this in the application or use a
stored procedure at this time.  The omission of such a construct from
psql's "\h" command and the manual is not in error.

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: counting algorithm for incremental matview maintenance
Next
From: Benedikt Grundmann
Date:
Subject: Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)