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

[Robert Coup]

Orlando Giovanny Solarte Delgado wrote:
> When I use an EXPRESSION in my map file using FIELD STRING, the 
> condition never returns as true, even though I know the values exist 
> in my table. <http://postgis.refractions.net/docs/ch04.html#id2525201>
>
> ...
>
> I am using both lower an upper case, I know VTS value exist in my 
> table postgis, but never returns as true.
Try checking that whitespace hasn't been added to the end of your string 
- the char_length() function can help you here. Also trim() will fix it 
for you. I had several million rows of attributes imported from MapInfo 
TAB format with these issues.

Rob :)