Re: replace function

* rute solipa <rutes@xxxxxxxxxxxx> [28.04.2003 18:08]:
> 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,

replace(string text, from text, to text)
See `String functions' in the PostgreSQL manual.

-- 

Victor Yegorov

pgpVUnl6cniiP.pgp
Description: PGP signature