Re: Replace function ... - Mailing list pgsql-sql

From Yasir Malik
Subject Re: Replace function ...
Date
Msg-id Pine.NEB.4.58.0405171532470.23482@pink-elephant.cs.stevens-tech.edu
Whole thread Raw
In response to Replace function ...  ("Kornelije" <krabuzin@foi.hr>)
List 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) textReplace 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-----


pgsql-sql by date:

Previous
From: "Kornelije"
Date:
Subject: Replace function ...
Next
From: "Stijn Vanroye"
Date:
Subject: Re: a wierd query