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

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: pgsql-questions(at)postgresql(dot)org
Subject: why doesn't insert into foo delete from bar returning baz work?
Date: 2010-05-26 15:17:56
Message-ID: 784F667A94DB68379ECD0E56@mangostan.pingpong.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2010-05-26 15:30:35 Re: reducing postgresql disk space
Previous Message Thom Brown 2010-05-26 15:05:22 Re: reducing postgresql disk space