Yes, I read the manual. I think I had a problem because of the special chars (< / >) that I'm trying to search for... Still looking for the right syntax. On 8/23/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote: > > 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 4: Have you searched our list archives? http://archives.postgresql.org/
