Thanks Adrian, On 2013-02-06, at 12:40 , Adrian Klaver <adrian.klaver@xxxxxxxxx> 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@xxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
