Re: Making joins involving ctid work for the benefit of UPSERT

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Making joins involving ctid work for the benefit of UPSERT
Дата
Msg-id CAM-w4HOnJuceFtBB4rFdEDxie0xqjTD9QO3S09sNedK0f=d8ew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Making joins involving ctid work for the benefit of UPSERT  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Verbose output of pg_dump not show schema name
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Making joins involving ctid work for the benefit of UPSERT