[postgis-users] Help: NULL to value

Zia Ahmed zua3 at cornell.edu
Thu Mar 26 12:45:57 PDT 2009

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.


More information about the postgis-users mailing list