| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stijn Vanroye | 2004-05-18 07:56:29 | Re: a wierd query |
| Previous Message | Richard Huxton | 2004-05-17 18:06:42 | Re: Max Columns in a SQL Select |