X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0782476389 for ; Mon, 28 Apr 2003 11:11:52 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 285C1476349 for ; Mon, 28 Apr 2003 11:11:47 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h3SFBoNL023211 for ; Mon, 28 Apr 2003 18:11:50 +0300 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Mon, 28 Apr 2003 18:11:48 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h3SFBmu24602 for ; Mon, 28 Apr 2003 18:11:48 +0300 Received: (qmail 28155 invoked by uid 100); 28 Apr 2003 15:13:30 -0000 Date: Mon, 28 Apr 2003 18:13:30 +0300 From: "Victor Yegorov" To: rute solipa Cc: "pgsql-sql@postgresql.org" Subject: Re: replace function Message-ID: <20030428151330.GA27788@nordlb.lv> Mail-Followup-To: rute solipa , "pgsql-sql@postgresql.org" References: <3EAD4293.30902@eselx.ipl.pt> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="k+w/mQv8wyuph6w0" Content-Disposition: inline In-Reply-To: <3EAD4293.30902@eselx.ipl.pt> User-Agent: Mutt/1.4.1i X-Spam-Status: No, hits=-37.8 required=5.0 tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/453 X-Sequence-Number: 13154 --k+w/mQv8wyuph6w0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * rute solipa [28.04.2003 18:08]: > hi everyone, >=20 > i've got an oracle query that goes like this: > select replace (v.ds_conf, 'ns', 'p/fazer') as conf. > from tb_visitas >=20 > the result of this query is everytime is find string 'ns' it will be=20 > replaced by 'p/fazer'. >=20 > does any one can tell me how do i do this in postgresql. >=20 > kind regards, replace(string text, from text, to text) See `String functions' in the PostgreSQL manual. --=20 Victor Yegorov --k+w/mQv8wyuph6w0 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+rUUa2RKGLEykUDYRAok0AJ9qFr98qawT6ZWq77XgzB1e+P2WxwCfVXnn KtbP2H8IyP42C5BOidvpkEU= =674A -----END PGP SIGNATURE----- --k+w/mQv8wyuph6w0--