why doesn't insert into foo delete from bar returning baz work?

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема why doesn't insert into foo delete from bar returning baz work?
Дата
Msg-id 784F667A94DB68379ECD0E56@mangostan.pingpong.net
обсуждение исходный текст
Ответы Re: why doesn't insert into foo delete from bar returning baz work?
Re: why doesn't insert into foo delete from bar returning baz work?
Список pgsql-general
While you can do

insert into foo (a, b) select a, b from bar;

and

delete from bar where a=1 returning a, b;

it fails to run

insert into foo (a, b) delete from bar where a=1 returning a, b;

This is not what I would expect. Is there a reason for it not working?

Cheers
Palle


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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: reducing postgresql disk space
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: reducing postgresql disk space