[postgis-users] itemnquery limitation

David Blasby dblasby at refractions.net
Fri Aug 8 09:25:08 PDT 2003


Tom Melhuish wrote:
> DECLARE mycursor BINARY CURSOR FOR 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') ))

Could you send me your .map file? and what your database table looks 
like (its not a view is it?).  Also, how many rows are there in the 
table.  how are you calling the itemnquery.  is your machine (or the 
database) "busy" during the query.

I assume you're using a DATA/FILTER combination - lets see if thats the 
problem.  Use something like this;

DATA "the_geom FROM (SELECT oid,* FROM nodescomb_2003 WHERE nodeid in 
(...)  ) as foo USING UNIQUE oid USING SRID=..."

Fill in your appropriate SRID # and the list of values.

dave







More information about the postgis-users mailing list