Re: How to extract a substring using Regex

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