> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Josh Trutwin
> Sent: Friday, August 24, 2007 7:58 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
>
> On Fri, 24 Aug 2007 06:31:58 +0100
> Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk> wrote:
>
> > > substring(data_field from '<name>(.+)<\/name>')
> >
> > FWIW, I find the following site extremely useful when trying to
> > create moderately complex regular expressions: http://www.rexv.org.
>
> Nice site - here's another good one for an installed app that is
> excellent for even advanced regexp's:
>
> http://weitz.de/regex-coach/
>
> It used to be cross-platform but now he only develops a Windows
> version.
>
> Thanks,
>
> Josh
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
As long as we are talking about regex tools... I found this tool a while
back and today I don't know how I ever figured out regular expressions
without it. (http://www.regexbuddy.com/) Unfortunately it is not free, but
for the time that it saves, it is WELL worth $40 a copy. In fact, I
personally bought it and was going to charge back to my company, but decided
I would keep the licenses myself.
This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the sender. This message
containsconfidential information and is intended only for the individual named. If you are not the named addressee you
shouldnot disseminate, distribute or copy this e-mail.