[Mapserver-DE] what is wrong with my postgis query:

Heinz-Josef Lücking h-j.luecking at ggs-bhv.de
Fre Mai 12 13:55:54 CEST 2006


Does anybody have an idea what is wrong with my query:

Warning: [MapServer Error]: prepare_database(): Error executing POSTGIS 
DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR 
FOR SELECT 
poikat::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::t
ext 
from (SELECT poigk3.gid AS gid, poigk3.poiid AS poiid, poigk3.the_geom 
AS the_geom, poi_customer.poikategorie AS poikat from poigk3, 
poi_customer where poi_customer.customerid='monavista' and 
poi_customer.licensee='bis_bhv' and poi_customer.poiid=poigk3.poiid) AS 
foo WHERE (poikat) and (the_geom && setSRID( 'BOX3D(3300000 
5600000,3800000 6100000)'::BOX3D,31467) )'

Postgresql reports the error as 'ERROR: argument of AND must be type 
boolean, not type integer '

thx, heinz




This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)