proposed todo: use insert/update returning anywhere a table is allowed

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема proposed todo: use insert/update returning anywhere a table is allowed
Дата
Msg-id b42b73150702061354y2db729acu55dc37c8a4e51db6@mail.gmail.com
обсуждение исходный текст
Ответы Re: proposed todo: use insert/update returning anywhere a table is allowed
Список pgsql-hackers
It would be great to be able to join to update, returning, etc.  It
looks like the code was deliberately tied off as-is and I was
surprised not to see a todo for this.

the basic idea is to be able to do things like:
select * from (update foo set id = 1 returning *) q;

which currently syntax errors out on 'set' which is a bit odd.

here are tom's brief notes on it and also some context on how select
combined with insert/update might influence triggers:

http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php

merlin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Status of autovacuum and the sporadic stats failures ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Status of autovacuum and the sporadic stats failures ?