Re: How can I pass an array to SPI_execute_with_args()? - Mailing list pgsql-general

Boszormenyi Zoltan <zb@cybertec.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