| From: | Rajesh Kumar Mallah <rmallah(at)trade-india(dot)com> |
|---|---|
| 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:08:37 |
| Message-ID: | Pine.LNX.4.33.0304282036300.645-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rute solipa | 2003-04-28 15:12:10 | Re: replace function |
| Previous Message | Rajesh Kumar Mallah | 2003-04-28 15:05:30 | Re: plpgsql Question.. |