[postgis-users] Help: NULL to value

[Zia Ahmed]

Thank you so much Nicklas! it works .

Zia

Nicklas Avén wrote:
> Hi
>
> this should do it:
>
> update thetable set thecolumn=100 where thecolumn is null or thecolumn >
> 100
>
> Hope that helps
> Nicklas
>
>
> tor 2009-03-26 klockan 15:45 -0400 skrev Zia Ahmed:
>   
>> Hi All,
>>
>> I have  a table where a column (type- numeric)  contains  several
>> thousands NULL-values. I want to covert all of these NULL values to
>> "100" and values  those are greater than "100",  I want to convert
>> these values to 100 too. How do  I do this? It will be appreciated if
>> someone help me out  to write the query.
>>
>> Zia
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>     
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090326/06114248/attachment.html>