I just ran something like:
=============================================
UPDATE my_table SET colname = NULL WHERE colname ~ '^\s*$'
=============================================
I got the following warnings/hints as a result:
=============================================
WARNING: nonstandard use of escape in a string literal
HINT: USE the escape string syntax for escapes, e.g., E'\r\n'.
UPDATE 500
=============================================
Oddly it actually updated, and did just exactly what I wanted! :-)
So what am I to make of those weird hints and warning?