update table_name set column_name= 100; --- On Fri, 3/27/09, Zia Ahmed <[email protected]> wrote:
From: Zia Ahmed <[email protected]> Subject: [postgis-users] Help: NULL to value To: [email protected] Date: Friday, March 27, 2009, 1:15 AM 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
