| From: | "Victor Yegorov" <viy(at)nordlb(dot)lv> |
|---|---|
| To: | rute solipa <rutes(at)eselx(dot)ipl(dot)pt> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: replace function |
| Date: | 2003-04-28 15:13:30 |
| Message-ID: | 20030428151330.GA27788@nordlb.lv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
* rute solipa <rutes(at)eselx(dot)ipl(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Teter | 2003-04-28 15:28:26 | Re: jsp postgres installation/configuration howto url |
| Previous Message | rute solipa | 2003-04-28 15:12:10 | Re: replace function |