Postgres Pro
Downloads
Home   >   mailing lists

Re: How to extract a substring using Regex - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: How to extract a substring using Regex
Date
Msg-id DA2AB8BA-73D4-4668-AF0D-CA7B0B332EC3@seespotcode.net
Whole thread Raw
In response to How to extract a substring using Regex  ("Postgres User" <postgres.developer@gmail.com>)
Responses Re: How to extract a substring using Regex  ("Postgres User" <postgres.developer@gmail.com>)
List pgsql-general
Tree view 
On Aug 23, 2007, at 19:33 , Postgres User wrote:

> I'm new to Regex in Postgres.  Can someone give me a quick pointer on
> how I'd SELECT the substring between   '<name>'    and  '</name>'  in
> a field?

Check out regexp_replace:

http://www.postgresql.org/docs/8.2/interactive/functions-
matching.html#FUNCTIONS-POSIX-REGEXP

One of the forms of substring might work for you, too.

Michael Glaesemann
grzm seespotcode net

pgsql-general by date:

Previous
From: "Postgres User"
Date:
Subject: How to extract a substring using Regex
Next
From: "Postgres User"
Date:
Subject: Re: How to extract a substring using Regex