[Mapserver-users] maximum length postgis data query?

[David Blasby]

Twan Kogels wrote:
>                 $data="pc_geom from pc6"
>                 ." "
>                 ." "
>                 ." "
>                 ." "
>                 ." "
>                 ." "
>                 ."USING UNIQUE oid USING SRID=-1";

I'm unable to reproduce your problem using the CVS version (4.0).

When I write a map file with a line in it like:

DATA "geom from test       USING UNIQUE oid USING SRID=-1"

it seems to work fine:

'DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(geom)),'NDR'),oid::text from test 
    WHERE geom && setSRID('BOX3D(1158000 366489.090909091,1209000 
417510.909090909)'::BOX3D, -1 )'

NOTE: there are a bunch of spaces between "test" and "WHERE".


dave