Just for clarity: In the documentation
(http://www.postgresql.org/docs/8.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
is mentioned "Flag g causes the function to find each match in the
string, not only the first one, and return a row for each such match. "
So in your example it was only
2010/2/27 :
> Hi!
>
> I am trying to replace characters '\r', '\n', or '\t' with space character '
> '. As an example, I want string "A\t\n\rB" becomes "AB". The following
> statement seems to be not working. What mistake have I made?
>
> TIA
>
> CN
>
>
> select regexp_replace(E'A\r\n\
Hi!
I am trying to replace characters '\r', '\n', or '\t' with space character ' '.
As an example, I want string "A\t\n\rB" becomes "AB". The following statement
seems to be not working. What mistake have I made?
TIA
CN
select regexp_replace(E'A\r\n\tB',E'[\r\n\t]',' ');
regexp_rep
