Thread: Sql problem
View Single Post

   
  #2 (permalink)  
Old 04-09-2008, 11:05 PM
Ben
 
Posts: n/a
Default Re: Sql problem

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@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote