Re: replace() and Regular Expressions

From: "DEV" <dev(at)umpa-us(dot)com>
To: "'A(dot) Kretschmer'" <andreas(dot)kretschmer(at)schollglas(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: replace() and Regular Expressions
Date: 2005-11-01 18:01:54
Message-ID: 20051101180225.EA8B7DB6D9@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of A. Kretschmer
Sent: Monday, October 31, 2005 1:43 PM
To: pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-01 18:12:07 Re: SQL injection
Previous Message Chris Browne 2005-11-01 17:20:58 Re: Oracle 10g Express - any danger for Postgres?