[Mapserver-users] null values in postgis

[Kathi Koebke]

Hey Vladimir,
Thank your for help. I was testing to work with the cast statement but 
it dosen't work . I think there is something work in my cast statement  
for postgresql and i have to check it out or to find another way, 
because I don't want to take hand on the original data. Could it be a 
bug in mapserver?
Hasta luego
Kathi

Vladimir Guzmán schrieb:

> I've had a simmilar problem, but with oracle, and what I did was a 
> casting, for example:
>
> data=the_geom FROM (SELECT CASE WHEN field IS NULL THEN ' ' ELSE 
> CAST(field AS VARCHAR) END AS field)
>
> And the expression would be:
> EXPRESSION ([field] = ' ')
>
> I don't know if there is a better way to do that, but it worked.
>
> Hope that helps,
>

-- 
Kathi Köbke
Projektkoordinatorin ENV

ZADI - Zentralstelle für
Agrardokumentation und -information
Villichgasse 17, D-53177 Bonn, Germany

Tel: +49 (228) 95 48 406
Fax: +49 (228) 95 48 111

E-Mail: koebke at zadi.de
http://www.zadi.de