replace function

From: rute solipa <rutes(at)eselx(dot)ipl(dot)pt>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: replace function
Date: 2003-04-28 15:02:43
Message-ID: 3EAD4293.30902@eselx.ipl.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-04-28 15:05:30 Re: plpgsql Question..
Previous Message Rod Taylor 2003-04-28 13:46:45 Re: plpgsql Question..