Postgres Pro
Downloads
Home   >   mailing lists

Re: regular expression - Mailing list pgsql-general

From Pavel Stehule
Subject Re: regular expression
Date
Msg-id Pine.LNX.4.44.0502141512130.24704-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to regular expression  (fiona <fbissett@blueyonder.co.uk>)
List pgsql-general
Tree view 
Hello,

You can use function translate

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

Regards
Pavel Stehule

pgsql-general by date:

Previous
From: Fred Blaise
Date:
Subject: replication question
Next
From: Robby Russell
Date:
Subject: Re: replication question