On Oct 7, 2007, at 9:44 AM, Anton Andreev wrote:
Hi, Can you tell me more about Postgresql string functions?
Have you had a look at http://www.postgresql.org/docs/8.2/interactive/ functions-string.html?
I want to replace a column text "1/2/3/8/" to the corresponding values to these values like "A, B, C, D".
Depending on how many different string mappings you have, nested regexp_replace calls may or may not be awkward to work with.
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly