[postgis-users] Help: NULL to value

Nicklas Avén nicklas.aven at jordogskog.no
Thu Mar 26 12:53:44 PDT 2009


this should do it:

update thetable set thecolumn=100 where thecolumn is null or thecolumn >

Hope that helps

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

More information about the postgis-users mailing list