[postgis-users] LWGEOM_gist_joinsel called with incorrect join type
Ben Madin
lists at remoteinformation.com.au
Tue Feb 2 23:04:39 PST 2010
G'day all,
In chasing a list of administrative areas, and the number of reports of disease from within each of them (based on point coordinates) I am using a left outer join from the admin polygon table to the outbreaks table, and st_covers
SELECT n.ccode, n.admin1, count(a5.id) AS "2009"
FROM new_prov n
LEFT OUTER JOIN ahis a5
ON st_covers(n.the_geom, a5.the_geom)
AND a5.startdate >='2009-01-01'
AND a5.startdate < '2010-01-01'
GROUP BY n.ccode, n.admin1
ORDER BY ccode, admin1;
are there any problems with getting this notice:
NOTICE: LWGEOM_gist_joinsel called with incorrect join type
From trial and error I find that just an (inner) JOIN doesn't give me the notice, but neither do I get a complete list of provinces.
Can I ignore the notice and be confident that I am getting the data I anticipate. Why is this a notice?
cheers
Ben
More information about the postgis-users
mailing list