* rute solipa <rutes@eselx.ipl.pt> [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