Re: "on existing update" construct

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "on existing update" construct
Date: 2013-05-15 19:51:11
Message-ID: CAAZKuFby5R4PrdnKLqcmLPbMJsjgPuFzOcgCcSa2ER0j7jsWDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, May 15, 2013 at 11:44 AM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-05-15 19:53:39 Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)
Previous Message Benedikt Grundmann 2013-05-15 19:50:49 Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)