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