Hi Jeff,
Thanks for the reply. Yes, I did see that example, and tried a number of different things to get it working for me, but to no avail. My log gets a bunch of statements that look like this: [Thu Jun 19 09:00:47 2014].144000 msPOSTGRESQLJoinClose() already close or never opened. Even if I did get that working, where would I put my GROUP BY sql query? In the TABLE attribute? Thanks! Tom Date: Wed, 18 Jun 2014 22:01:47 -0300 From: Jeff McKenna <[email protected]> To: [email protected] Subject: Re: [mapserver-users] Grouping Postgres and join with Shapefile Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1 Are you aware of the JOIN docs, with an example of how to join shp to Postgres? http://www.mapserver.org/mapfile/join.html#example-2-join-from-shape-dataset -to-postgresql-table I created that example years ago but it is still valid. -jeff
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
