Thanks Adrian, On 2013-02-06, at 12:40 , Adrian Klaver <adrian.kla...@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 -- Ben Madin m : +61 448 887 220 e : b...@ausvet.com.au -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
