On Sun, May 18, 2008 at 1:40 AM, Hamish <[EMAIL PROTECTED]> wrote: ... > Or figure out how to make this safe for floating point comparison on the > $VALUE > column without keeping the cat column: > (my SQL is very poor) > UPDATE $TABLE SET $GIS_OPT_RGB_COLUMN = '$COLR' WHERE $GIS_OPT_COLUMN = > $VALUE
Something I found here: PG: http://www.nabble.com/Re%3A--GENERAL--SELECT-with-REAL...-p2791587.html SQlite: http://www.nabble.com/Problem-with-floating-point-fields%2C-and-a-feature-request-td909387.html#a909387 MySQL: http://www.nabble.com/Re%3A-float-comparison--p1285713.html Markus _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
