Description
Examples would include:
UPSERT INTO my_table (first_name, last_name, my_array)
VALUES ('John','Smith',ARRAY[25000,25000,27000,27000]);
UPSERT INTO my_table (first_name, last_name, my_array)
SELECT first_name,last_name, ARRAY[25000,25000,27000,27000]);