[Mapserver-users] null values in postgis

[Vladimir Guzmán]

Hello, Kathi.
Could you post the data statement you're trying to use?
Tschuess,

-- 
Vladimir Ilich Guzmán R.
------------------------
http://maintask.com 


Kathi Koebke wrote:

> 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,
>>
>