Re: Invalid syntax for integer

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