CREATE OR REPLACE FUNCTION rc_test_update_m_values( gid int,OUT gid_plus_1 int, OUT gid_minus_1 int) AS $$ -- @brief : test function, can be deleted BEGIN SELECT gid+1,gid-1 INTO gid_plus_1, gid_minus_1; RETURN ; END; $$ LANGUAGE 'plpgsql' IMMUTABLE STRICT ;
UPDATE test_update_m_values SET (gid_plus_1,gid_minus_1) = (rc_test_update_m_values(gid)); --doesn't work