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