Re: A few questions about carriage returns (\r) - Mailing list pgsql-general

Martijn van Oosterhout wrote:
> # select replace('aac','a','b');
>  replace
> ---------
>  bbc
> (1 row)
>
> So replace(str, '\r', '\\r') should work

Perfect, thanks.

I guess I'm blind, I didn't see this in the docs.  :)

-Jon

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham  <lapham@jandr.org>                Rio de Janeiro, Brasil
  Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------