Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-04 Thread Adrian Klaver
On 02/04/2016 01:35 PM, drum.lu...@gmail.com wrote: On 4 February 2016 at 12:03, David G. Johnston mailto:david.g.johns...@gmail.com> >> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-04 Thread drum.lu...@gmail.com
> > >> On 4 February 2016 at 12:03, David G. Johnston >> mailto:david.g.johns...@gmail.com>> wrote: >> >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com >> > >wrote: >> >> Hi all, >> >> Below is an example

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread Adrian Klaver
On 02/03/2016 03:09 PM, drum.lu...@gmail.com wrote: On 4 February 2016 at 12:03, David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com mailto:drum.lu...@gmail.com>>wrote: Hi all,

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread John R Pierce
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

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread David G. Johnston
On Wed, Feb 3, 2016 at 4:09 PM, drum.lu...@gmail.com wrote: > > > On 4 February 2016 at 12:03, David G. Johnston > wrote: > >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com < >> drum.lu...@gmail.com> wrote: >> >>> Hi all, >>> >>> Below is an example of the auto-generated update query, wit

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread Andreas Joseph Krogh
På torsdag 04. februar 2016 kl. 00:09:41, skrev drum.lu...@gmail.com < drum.lu...@gmail.com >:     On 4 February 2016 at 12:03, David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread drum.lu...@gmail.com
On 4 February 2016 at 12:03, David G. Johnston wrote: > On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com > wrote: > >> Hi all, >> >> Below is an example of the auto-generated update query, with >> client-supplied keys (_iid). There's a fatal error when _iid is not >> numeric. However; this s

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread David G. Johnston
On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com wrote: > Hi all, > > Below is an example of the auto-generated update query, with > client-supplied keys (_iid). There's a fatal error when _iid is not > numeric. However; this should accept any value. > > *Question:* How could I do something t