substring replacement - Mailing list pgsql-sql

From Oleg Lebedev
Subject substring replacement
Date
Msg-id 3BEB0B18.3D6604DA@waterford.org
Whole thread Raw
Responses Re: substring replacement  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Hi everybody,
I am wondering if there is an efficient way to get rid of line breaks
('\n') and tabs ('\t') from a string. Suppose, I have the following
query:
SELECT description
FROM device;
I don't want the returned description column to contain '\n' and '\t'.
Is it possible to do it efficiently?
thanks,

Oleg



pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Can this query be optimized?
Next
From: Tom Lane
Date:
Subject: Re: Increasing MAX_ARGS