Sql problem

Started by Anton Andreevover 18 years ago2 messagesgeneral
Jump to latest
#1Anton Andreev
fn30762@fmi.uni-sofia.bg

Hi,

Can you tell me more about Postgresql string functions?
I want to replace a column text "1/2/3/8/" to the corresponding values
to these values like "A, B, C, D".

Cheers,
Anton Andreev

#2Ben
bench@silentmedia.com
In reply to: Anton Andreev (#1)
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.