Re: ERROR: invalid input syntax for integer: ""

Thanks Adrian,

On 2013-02-06, at 12:40 , Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:

> I am not seeing anything obvious.
> Is there a chance the import to the second machine did not go well?

Actually, these queries work on the machine that the import was done to - but not the original. However, not all is well on the development machine, I've sent a further email.

> Have you looked at the values for id and reportid to see if they look alright?

Yes, those I've scanned seem OK - I've tried some tests looking for nulls etc. (there are several million reports, and about 30 times as many results, hence I'm not posting a reproducible example - yet!)

cheers

Ben

--

Ben Madin

m : +61 448 887 220
e : ben(at)ausvet(dot)com(dot)au