Re: Sql problem

From: Ben <bench(at)silentmedia(dot)com>
To: anton(dot)andreev(at)fmi(dot)uni-sofia(dot)bg
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sql problem
Date: 2007-10-07 17:40:44
Message-ID: 4E3ADD7B-A339-4436-B48D-2C17AB6294EA@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

  • Sql problem at 2007-10-07 16:44:36 from Anton Andreev

Browse pgsql-general by date

  From Date Subject
Next Message michi 2007-10-07 17:54:49 Re: PostgreSQL Storage: Sorted by Primary Key?
Previous Message Christopher Browne 2007-10-07 17:01:38 Re: PostgreSQL Storage: Sorted by Primary Key?