[postgis-users] postgis bool::text and mapserver

[Didrik Pinte]

Hi,

I have a problem using the latest Postigs package of the Debian GIS
project with Debian/Sarge Mapserver package (4.4).

When using boolean in EXPRESSION, the test does not work. And nothing
displays...

For example : 

Here is the mapserver class :

                CLASS
                        NAME "test"
                        EXPRESSION ([moved] = 't')
                        COLOR 255 0 0
                        OUTLINECOLOR 255 0 0
                        SIZE 10
                        SYMBOL "circle"
                END


And here is the table definition  :

CREATE TABLE mapping
(
  id varchar(50) NOT NULL, 
  moved bool DEFAULT false,
  cartopoint geometry,
  CONSTRAINT id PRIMARY KEY (id),
  CONSTRAINT enforce_dims_cartopoint CHECK (ndims(cartopoint) = 2),
  CONSTRAINT enforce_geotype_cartopoint CHECK (geometrytype(cartopoint)
= 'POINT'::text OR cartopoint IS NULL),
  CONSTRAINT enforce_srid_cartopoint CHECK (srid(cartopoint) = 4326)
) 


When using psql, it works perfectly well : 

select text(moved) from tblgeomapping where text(moved)='t';

As anybody an idea on the source of the problem ?

Thanks a lot in advance for any help.

Didrik Pinte
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050509/112bdaef/attachment.pgp>