Boszormenyi Zoltan <zb(at)cybertec(dot)at> writes:
> I would like to execute the code below.
Since you're apparently deconstructing and reconstructing the array
anyway, why don't you do the insertion at the C-array stage, and
do just one construct_array() that yields the final result?
> If the above marked line sets oids[1] = INT8OID, I get this error:
> ERROR: function array_append(anyarray, bigint) does not exist
> LINE 1: UPDATE product.t_product_inv SET ids = array_append($1, $2) ...
> ^
You'd need to use the types int8[] and int8, explicitly. No ANYARRAY.
regards, tom lane