[postgis-users] itemnquery limitation

[Tom Melhuish]

Dave,

Yes, as my note stated, I tried this in psql and it works fine. I't
something internal when running with mapserv.

tom

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
Blasby
Sent: Wednesday, August 06, 2003 12:45 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


Tom Melhuish wrote:
> 22 Items - fails

Whats the error message?

Have you tried entering:

SELECT
nodeid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
from nodescomb_2003 WHERE (nodeid in
('413.0','430.0','431.0','432.0','433.0','434.0','436.1','450.0','451.0','45
2.0',
'453.0','454.0','455.0','456.0','457.1','457.2','457.3','457.4','458.1','458
.2','459.0','528.0')) and (the_geom && setSRID( 'BOX3D(2001272.875
643833.625,2099924.5
696954.5)'::BOX3D,find_srid('','nodescomb_2003','the_geom') ))


into psql?

dave


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users