[mapserver-users] Grouping Postgres and join with

[Tom]

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 <jmckenna at gatewaygeomatics.com>
To: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Grouping Postgres and join with
Shapefile
Message-ID: <53A2367B.2060608 at gatewaygeomatics.com>
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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140619/7c68b85f/attachment.htm>