From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: replace() and Regular Expressions |
Date: | 2005-11-01 18:20:14 |
Message-ID: | 20051101182014.GA2335@webserv.wug-glas.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
am 01.11.2005, um 13:01:54 -0500 mailte DEV folgendes:
> Currently I am running 8.0.1. Looks like an upgrade is in my future. Oh
> Joy!!!! LOL
>
> 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'.
Other solution:
use plpgperl to use regex-functions.
Btw.: http://www.vranx.de/mail/tofu.html
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Bloebaum | 2005-11-01 18:22:55 | Re: Oracle 10g Express - any danger for Postgres? |
Previous Message | Scott Marlowe | 2005-11-01 18:18:59 | Re: SQL injection |