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

[James Martin]

Thank you both for your suggestions, I actually have
tried DISTINCT and LIMIT already to no avail.  I shall
try your suggestion regarding the mapserver e-mail
list as well.

Interestingly, if I remove the WHERE class and bound 2
points, it will then pull the first record 2 * N
times...  

-James
--- Ethan Alpert <ealpert at digitalglobe.com> wrote:

> 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
> 
> 
> > _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com