Обсуждение: Sql problem

Поиск
Список
Период
Сортировка

Sql problem

От
Anton Andreev
Дата:
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


Re: Sql problem

От
Ben
Дата:
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.