substring replacement

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: substring replacement
Date: 2001-11-08 22:45:44
Message-ID: 3BEB0B18.3D6604DA@waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message fstelpstra@yahoo.com 2001-11-09 00:26:32 Re: Can this query be optimized?
Previous Message Jeff Sack 2001-11-08 21:54:59 Optimizing