Re: replace function in a query

Поиск
Список
Период
Сортировка
Искать
От
William Leite Araújo
Тема
Re: replace function in a query
Дата
в 08:44:34
Msg-id
bc63ad820705210444r6c9c9b99q6b70f14ed70945fe@mail.gmail.com
Ответ на
replace function in a query (Harpreet Dhaliwal)
Список
Дерево обсуждения
replace function in a query "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: replace function in a query "William Leite Araújo" <william.bh@gmail.com>
    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



2007/5/21, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com>:
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



--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
В списке pgsql-general по дате отправления
Предыдущее
От: Harpreet Dhaliwal
Дата:
Сообщение: replace function in a query
Следующее
От: Raymond O'Donnell
Дата:
FAQ