replace function in a query - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject replace function in a query
Date
Msg-id d86a77ef0705210435v7a6e9e39w4d9eceace5d14963@mail.gmail.com
Whole thread Raw
Responses Re: replace function in a query
List pgsql-general
Hi,

I have to write a query that does the following.

select column_x from tbl_xyz
where column_y = 'abc def ghi'

new line characters i.e. '\n' in column_y should be replaced with a space character i.e. ' ' in this query.
Is there any replace function that when used in the query with colulmn_y would do it?

Thanks,
~Harpreet

pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: TSearch2 memory usage
Next
From: "William Leite Araújo"
Date:
Subject: Re: replace function in a query