Re: regular expression

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: fiona <fbissett(at)blueyonder(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: regular expression
Date: 2005-02-14 14:14:36
Message-ID: Pine.LNX.4.44.0502141512130.24704-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

You can use function translate

testdb011=# select
translate('XY1X234X','qwertyuioplkjhgfdsazxcvbnmQWERTYUIOPLKJHGFDSAZXCVBNM','');
translate
-----------
1234
(1 row)

Regards
Pavel Stehule

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fred Blaise 2005-02-14 14:18:03 replication question
Previous Message Shridhar Daithankar 2005-02-14 14:06:44 Re: PostgreSQL vs. MySQL vs. Oracle, 2005 report card