Re: Regular expressions in procs

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Regular expressions in procs
Date: 2007-06-13 14:46:04
Message-ID: 1181745964.430170.119790@g37g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 13, 9:02 am, sma(dot)(dot)(dot)(at)magpie(dot)com (Steve Manes) wrote:
> I apologize if I'm having a rookie brain block, but is there a way to
> massage a string inside a proc to, for instance, strip it of all
> non-alpha characters using a regular expression?

regexp_replace() could work for you, see:
http://www.postgresql.org/docs/8.2/static/functions-string.html
http://www.postgresql.org/docs/8.2/static/functions-matching.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-06-13 15:43:19 Re: pg_xlog - files are guaranteed to be sequentialy named?
Previous Message Leif B. Kristensen 2007-06-13 14:42:58 Re: psql : Error: Cannot stat /pgdata/8.2/main