On 2/3/2016 3:32 PM, Andreas Joseph Krogh wrote:
> This query works for me in 9.5:
> SELECT CAST(customer_id AS BIGINT), csv_data, freshbooks_id, myob_id,
> ppy_id, qb_id, xero_id, _iid FROM ( VALUES ('3915105', E'\x1A',
> E'\x1A', 'c59894cb-0ffe-4ad6-823d-73c1392142b6', E'\x1A', E'\x1A',
> E'\x1A', '44'), ('3915135', E'\x1A', E'\x1A',
> 'fe88ff8f-6b4d-4e3d-8020-3475a101d25e', E'\x1A', E'\x1A', E'\x1A',
> 'fe88ff8f-6b4d-4e3d-8020-3475a101d25e') ) AS id(customer_id, csv_data,
> freshbooks_id, myob_id, ppy_id, qb_id, xero_id, _iid);
it works on 9.2 for me here, as well as 9.3, 9.4
--
john r pierce, recycling bits in santa cruz