Re: Fatal error when not numeric value - PostgreSQL 9.2

[John R Pierce <pierce@xxxxxxxxxxxx>]

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