replace function - Mailing list pgsql-sql

From rute solipa
Subject replace function
Date
Msg-id 3EAD4293.30902@eselx.ipl.pt
Whole thread Raw
Responses Re: replace function  (Rajesh Kumar Mallah <rmallah@trade-india.com>)
Re: replace function  ("Victor Yegorov" <viy@nordlb.lv>)
List pgsql-sql
hi everyone,

i've got an oracle query that goes like this:
select  replace (v.ds_conf, 'ns', 'p/fazer') as conf.
from tb_visitas

the result of this query is everytime is find string 'ns' it will be 
replaced by 'p/fazer'.

does any one can tell me how do i do this in postgresql.

kind regards,

rute



pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: plpgsql Question..
Next
From: rute solipa
Date:
Subject: Re: replace function