Hi, Can anyone explain this message to me & whether it indicates anything I should be concerned about?
The stations table contains some 47,000 undersea sample sites. The other tables represent points of observations of various properties such as depth or temperature. The query is to return an indicative value for each property for each station. The left outer join is required to ensure all station records are returned, whether or not there is a nearby value for any property. The notice message only occurs when an outer join is specified, if it is not an outer join, then no message appears. The query appears to work fine, but I don't know the significance of the message, or what I have done to cause it. I figure that being a notice, rather than error or warning, it is not critical, but.... Any advice appreciated... Brent Wood select s.ogc_fid, s.trip::integer as trip, s.station::varchar(20) as station, avg(d.depth)::decimal(6,2) as avg_depth, avg(t.botemp)::decimal(8,6) as avg_botemp, avg(a.aou)::decimal(8,6) as avg_aou from allstations s left outer join depths d on d.geom && buffer(s.wkb_geometry,125) left outer join botemp t on t.geom && buffer(s.wkb_geometry,125) left outer join aou a on a.geom && buffer(s.wkb_geometry,125) where s.ogc_fid < 100 group by s.ogc_fid, s.trip, s.station order by s.ogc_fid; NOTICE: LWGEOM_gist_joinsel called with incorrect join type NOTICE: LWGEOM_gist_joinsel called with incorrect join type NOTICE: LWGEOM_gist_joinsel called with incorrect join type
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
