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

[Didrik Pinte]

Le lundi 09 mai 2005 à 07:26 -0700, Paul Ramsey a écrit :
> Two possible things:
> 
> SELECT true::text
> 
> and see what the text representation to boolean is.
> I think to do string comparisons in mapserver you use 'eq' instead of 
> '='.
> 
> Paul

Hi Paul,

Here are the information : 

[1] ::text conversion

test=# select true::text;
 text
------
 t
(1 ligne)

I've also tested if there is no hidden whitespace over there :

nh3=# select char_length(true::text);
 char_length
-------------
           1
(1 ligne)

[2] Mapserver EXPRESSION :

I've just tested my expression like this :

EXPRESSION ( [moved] eq 't') 

but it does not work ...

When I export the information to a shapefile, it works great.

Didrik
-------------- 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/043d1c9c/attachment.pgp>