Re: Substitute - Mailing list pgsql-sql

From Milen A. Radev
Subject Re: Substitute
Date
Msg-id etq779$8ld$1@sea.gmane.org
Whole thread Raw
In response to Substitute  (Judith <jaltamirano@correolux.com.mx>)
List pgsql-sql
Judith написа:
> Hello everybody....
> 
> somebody knows, how I can substitute in a query if a field contains a
> character that I want to be shown with other character?
> 
> for example if I have a \n I want to shows me a ~ in the result of the
> select
> 

Look for 'replace' here -
http://www.postgresql.org/docs/8.2/static/functions-string.html.


-- 
Milen A. Radev



pgsql-sql by date:

Previous
From: Judith
Date:
Subject: Substitute
Next
From: Michael Fuhr
Date:
Subject: Re: Substitute