Postgres Pro
Downloads
Home   >   mailing lists

Re: replace() and Regular Expressions - Mailing list pgsql-general

From DEV
Subject Re: replace() and Regular Expressions
Date
Msg-id 20051101180225.EA8B7DB6D9@svr1.postgresql.org
Whole thread Raw
In response to Re: replace() and Regular Expressions  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
Currently I am running 8.0.1.  Looks like an upgrade is in my future. Oh
Joy!!!! LOL

Thank you!

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of A. Kretschmer
Sent: Monday, October 31, 2005 1:43 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] replace() and Regular Expressions
Importance: High

am  31.10.2005, um 13:11:20 -0500 mailte DEV folgendes:
> Is is possible to use replace along with regular expression to remove any
> and all punctuation from a field?

Which version?

PG 8.1 have a function 'regex_replace'.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: SQL injection
Next
From: Chris Browne
Date:
Subject: Re: Oracle 10g Express - any danger for Postgres?