Skip site navigation (1) Skip section navigation (2)

Re: Replace function ...

From: Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu>
To: Kornelije <krabuzin(at)foi(dot)hr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Replace function ...
Date: 2004-05-17 19:34:42
Message-ID: Pine.NEB.4.58.0405171532470.23482@pink-elephant.cs.stevens-tech.edu (view raw or flat)
Thread:
Lists: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I need to write a function which has to replace a character with two or three other characters ....
>

You can use the replace function as specified below:
replace(string text, from text, to text) text
 Replace all occurrences in @string of substring @from with substring @to.

replace( 'abcdefabcdef', 'cd', 'XX') ==> abXXefabXXef

Yasir
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (NetBSD)

iQEVAwUBQKkT1+J7vYSSIbWdAQL/5QgAmCdJrYh4YjJFWKeWNk+OEuhpvRNYbRlM
tH5dezmUrR4fkM4l2mfrmuIkTT+rqQNyRR3E5PhKyfkbnHdw7/WPalqGSbX1aIfP
YZI/RdxH/Aqy+hO+zcUQzSjpYSEyKrmTVGLmRf+tyYg0QdZdAQFd6O9aKWMeCo28
TFKRFAlg+glT/YiN1JiwzF/QygBNmo3g+JDWZ+U8Au+y0fHh/3KeoyLx9ipMSqs/
uBiy8eNjOdAF3ihoydDw2uBpzjwtGv9eeR0Myh8m4Zvx9K239NVSz4s9a+2R1Onf
Mr5PK7Te5TG8TLcjJyo35x8yC/57oufNvWoi+Q6Y7cmSxeiEcHzJiw==
=xChX
-----END PGP SIGNATURE-----

In response to

pgsql-sql by date

Next:From: Stijn VanroyeDate: 2004-05-18 07:56:29
Subject: Re: a wierd query
Previous:From: Richard HuxtonDate: 2004-05-17 18:06:42
Subject: Re: Max Columns in a SQL Select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group