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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
