Re: new rows based on existing rows

On 3 May 2012, at 24:00, Tom Lane wrote:

> Andy Chambers <achambers(at)mcna(dot)net> writes:
>> So ideally, I'd like to be able to do
>
>> insert into foo (a,b,foo_date)
>> select a,b,now() from foo old where ....
>> returning oid, old.oid
>
>> ...but this doesn't work. It seems you only have access to the table
>> being modified in a returning clause.
>
> For the moment I think all you could really do is what somebody else
> suggested, namely eat the overhead of having an "old_id" column in
> the table so that you can insert the value you want into that column,
> thus making it available to the RETURNING clause.

I was wondering, would an updatable view with a "pseudo-column" for the old_id do it?

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.