CREATE TEMP TABLE invoice_insert_result (stock_invoice_id integer) ON COMMIT DROP;
  WITH invoice_insert as (INSERT INTO stock.stock_invoice (invoice_num, invoice_date, upload_date, amount, quantity)
    SELECT
      invoice_num,
      invoice_date,
      upload_date,
      amount,
      quantity
    FROM json_populate_recordset(null :: stock.stock_invoice, invoice_json :: json)
  RETURNING stock_invoice_id)
  INSERT INTO invoice_insert_result (stock_invoice_id) SELECT * FROM  invoice_insert;