Re: Making joins involving ctid work for the benefit of UPSERT - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Making joins involving ctid work for the benefit of UPSERT
Date
Msg-id CAM-w4HOnJuceFtBB4rFdEDxie0xqjTD9QO3S09sNedK0f=d8ew@mail.gmail.com
Whole thread Raw
In response to Re: Making joins involving ctid work for the benefit of UPSERT  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Jul 23, 2014 at 5:58 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> I'd suggest something like:
>
> UPSERT table SET col = value [, ...] WHERE predicate;

I don't think this is actually good enough. Typical use cases are
things like "increment this counter or insert a new one starting at
0".

-- 
greg



pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Verbose output of pg_dump not show schema name
Next
From: Kevin Grittner
Date:
Subject: Re: Making joins involving ctid work for the benefit of UPSERT