Re: replace function

On Mon, 28 Apr 2003, rute solipa wrote:

> 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'.



It works exactly the same way here :)
in postgresql 7.3.x it is inbuilt , in older
version it can be installed from the postgresql
cookbook website ,


Regds
mallah.


> 
> does any one can tell me how do i do this in postgresql.
> 
> kind regards,
> 
> rute
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>