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

Thanks Adrian,

On 2013-02-06, at 12:40 , Adrian Klaver <adrian.klaver@gmail.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


--=20

Ben Madin

m : +61 448 887 220
e : ben@ausvet.com.au