[postgis-users] postgis bool::text and mapserver
Robert Coup
robert.coup at onetrackmind.co.nz
Mon Nov 13 12:11:43 PST 2006
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 :)
More information about the postgis-users
mailing list