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

Stephen Woodbridge woodbri at swoodbridge.com
Mon May 9 07:56:17 PDT 2005


Try EXPRESSION ( [moved] =~ /t/)

-Steve

Didrik Pinte wrote:
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list