On Thu, Mar 11, 2010 at 11:24 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Merlin Moncure escribió:
>
>
>> (small aside: the other biggie would be able to push a composite type
>> in to an update statement...something like 'update foo set foo =
>> new'). This is really great...some variant of this question is
>> continually asked it seems.
>
> Can't you already do that with EXECUTE ... USING NEW? hmm, ah, but you
> have to specify the columns in NEW, so it doesn't really work for you,
> does it?
right...with inserts you can expand the composite type without listing
the columns. updates can't do it because of syntax issues, even if
you go dynamic.
merlin