=?UTF-8?Q?R=C3=A9mi_Cura?= <remi.c...@gmail.com> writes:
> IF I define a function returning several values , I can't use it to update
> mutliple columns of a table at once.
> ...
> UPDATE test_update_m_values SET (gid_plus_1,gid_minus_1) =
> (rc_test_update_m_values(gid)); --doesn't work
> Somebody now if this is possible?
Not currently. In 9.5 it'll be possible to do
UPDATE test_update_m_values SET (gid_plus_1,gid_minus_1) =
(select * from rc_test_update_m_values(gid));
but the syntax you were trying will never work, because it would be
ambiguous with the case of assigning a composite value to a single
composite column.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
