David Jarvis <thangalin(at)gmail(dot)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