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@xxxxxxxxx> Rio de Janeiro, Brasil Personal: http://www.jandr.org/ ***-*--*----*-------*------------*--------------------*---------------