David Johnston <polobo(at)yahoo(dot)com> writes:
>> Is here less clumsy way to set array[position] to the new_value (not update but just change an element inside an array) than:
>>
>> SELECT
>> _array[1:pos-1]
>> ||newval
>> ||_array[_pos+1:array_length(_array, 1)]
> I do not know if there is a cleaner way but regardless you should code
> your logic as a function.
Inside a plpgsql function, you could just do
array[pos] := newval;
so perhaps it'd be worth creating a helper function that's a wrapper
around that.
regards, tom lane