replace function in a query

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: replace function in a query
Date: 2007-05-21 11:35:19
Message-ID: d86a77ef0705210435v7a6e9e39w4d9eceace5d14963@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Leite Araújo 2007-05-21 11:44:23 Re: replace function in a query
Previous Message Hannes Dorbath 2007-05-21 11:06:20 Re: TSearch2 memory usage