On Fri, 24 Aug 2007 06:31:58 +0100 Mark Cave-Ayland <mark.cave-ayland@xxxxxxxxxxxx> wrote: > > substring(data_field from '<name>(.+)<\/name>') > > FWIW, I find the following site extremely useful when trying to > create moderately complex regular expressions: http://www.rexv.org. Nice site - here's another good one for an installed app that is excellent for even advanced regexp's: http://weitz.de/regex-coach/ It used to be cross-platform but now he only develops a Windows version. Thanks, Josh ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/