Re: replace function - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Re: replace function
Date
Msg-id Pine.LNX.4.33.0304282036300.645-100000@localhost.localdomain
Whole thread Raw
In response to replace function  (rute solipa <rutes@eselx.ipl.pt>)
List pgsql-sql
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
> 



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PERFORM] Like search performance.
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: plpgsql Question..