Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid syntax for integer - Mailing list pgsql-novice

From Tom Lane
Subject Re: Invalid syntax for integer
Date
Msg-id 634.1278025894@sss.pgh.pa.us
Whole thread Raw
In response to Invalid syntax for integer  (David Jarvis <thangalin@gmail.com>)
Responses Re: Invalid syntax for integer
Re: Invalid syntax for integer
List pgsql-novice
Tree view 
David Jarvis <thangalin@gmail.com> writes:
> The error message is:
>   ERROR:  invalid input syntax for integer: "-123.1833"

Presumably, this is coming from where you try to assign the result of
array_agg to v_id.  Have you looked at what's going to be assigned
there?

            regards, tom lane

pgsql-novice by date:

Previous
From: David Jarvis
Date:
Subject: Invalid syntax for integer
Next
From: David Jarvis
Date:
Subject: Re: Invalid syntax for integer