[postgis-users] Help: NULL to value

[muhammad imran]

update table_name
set column_name= 100;

--- On Fri, 3/27/09, Zia Ahmed <zua3 at cornell.edu> wrote:


From: Zia Ahmed <zua3 at cornell.edu>
Subject: [postgis-users] Help: NULL to value
To: postgis-users at postgis.refractions.net
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
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/e6ce62f9/attachment.html>