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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
