Re: Fatal error when not numeric value - PostgreSQL 9.2

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);

-- 
john r pierce, recycling bits in santa cruz