Bo Pedersen
Member²
I'm not sure if this has been reported before, but the beautifier puts the returning clause in an update at the end of the line instead of on a new line:
update common.configuration t
set t.value = p_value
where t.system = p_system and t.type = p_type and p.name = p_name returning id into l_id;
It works correctly for an insert statement.
Bo Pedersen
update common.configuration t
set t.value = p_value
where t.system = p_system and t.type = p_type and p.name = p_name returning id into l_id;
It works correctly for an insert statement.
Bo Pedersen