Re: Invalid syntax for integer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Jarvis <thangalin(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Invalid syntax for integer
Date: 2010-07-01 23:11:34
Message-ID: 634.1278025894@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Jarvis 2010-07-02 00:50:48 Re: Invalid syntax for integer
Previous Message David Jarvis 2010-07-01 22:24:47 Invalid syntax for integer