[postgis-users] Postgis Mapserver Query returns the same itemmultiple times.

[Ethan Alpert]

I don't think this is what he wants as it will affect how many features
are displayed in the map. Perhaps a "distinct" clause? 
 
Also James are you sure gid is indeed unique for each place? I can't see
why it would work like you expect at first glance. You may want to ask
this on the mapserver email list.
 
 
-e

	-----Original Message-----
	From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Purvis, Charlton
	Sent: Wednesday, November 17, 2004 9:33 AM
	To: 'PostGIS Users Discussion'
	Subject: RE: [postgis-users] Postgis Mapserver Query returns the
same itemmultiple times. 
	
	

	You could try adding 'limit 1' after the WHERE clause (I think)
if that is what you want. 

	> -----Original Message----- 
	> From: James Martin [mailto:martin426 at yahoo.com] 
	> Sent: Wednesday, November 17, 2004 11:17 AM 
	> To: postgis-users at postgis.refractions.net 
	> Subject: [postgis-users] Postgis Mapserver Query returns the
same item 
	> multiple times. 
	> 
	> Hello, 
	> 
	> Any help is greatly appreciated. 
	> 
	> I'm trying to perform an nquery using the following 
	> DATA statement in my mapfile (formatted for e-mail): 
	> 
	> DATA = "the_geom from 
	> (SELECT place.the_geom AS the_geom, 
	>              place.gid AS gid, 
	>              place.name AS name 
	>              FROM place 
	>              WHERE place.gid=9) 
	>              AS foo USING UNIQUE place.gid 
	>              USING SRID=-1" 
	> 
	> Whenever I run this query on a map it works, that is 
	> to say there are no error messages and the information 
	> I'm expecting is returned. 
	> 
	> The problem is it returns the information 'N' times, 
	> where N is the number of rows in the place table. 
	> 
	> 
	> 
	> __________________________________________________ 
	> Do You Yahoo!? 
	> Tired of spam?  Yahoo! Mail has the best spam protection
around 
	> http://mail.yahoo.com 
	> _______________________________________________ 
	> postgis-users mailing list 
	> postgis-users at postgis.refractions.net 
	> http://postgis.refractions.net/mailman/listinfo/postgis-users 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20041117/23aeaf15/attachment.html>