>>>>> "PG" == PG Bug reporting form <noreply@postgresql.org> writes:
PG> select upper(regexp_replace(a, '\\s+', '')) as keyword
This regexp doesn't do what you seem to be expecting. With
standard_conforming_strings enabled, which is the default, \ is not a
special character to the string literal parser, so the regexp engine is
seeing a regexp of \\s+ which means "match the literal character \
followed by one or more lowercase "s" characters". Accordingly the
regexp never matches on your input.
To remove whitespace use '\s+' or E'\\s+' or '[[:space:]]+'
--
Andrew (irc:RhodiumToad)
