David Johnston <polobo@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
