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

On Wed, May 26, 2010 at 11:17 AM, Palle Girgensohn <girgen(at)pingpong(dot)net> wrote:
> 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?

everyone wants this. it was slated to be included for 9.0 but the
patch had to be pulled due to technical problems.

merlin