Thread: replace function in a query

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

    http://www.postgresql.org/docs/8.0/interactive/functions-string.html
    http://www.postgresql.org/docs/8.1/interactive/functions-string.html
    http://www.postgresql.org/docs/8.2/interactive/functions-string.html






--
William Leite Araújo
Analista de Banco de Dados - QualiConsult

> 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?

Are you looking for something like this?

test=> SELECT translate ('abc
test'> def
test'> ghi', E'\n', ' ');
  translate
-------------
 abc def ghi
(1 row)

"translate" is described on
http://www.postgresql.org/docs/current/static/functions-string.html

Yours,
Laurenz Albe