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 <[EMAIL PROTECTED]>:
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
