On Thu, Mar 11, 2010 at 11:24 PM, Alvaro Herrera <alvhe...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
