[postgis-users] Help: NULL to value

[Nicklas Avén]

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
>