[postgis-users] itemnquery limitation

[David Blasby]

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