Re: How to extract a substring using Regex

["Postgres User" <postgres.developer@xxxxxxxxx>]

> > 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.
>
> Why don't you show us what you've tried and the errors you're
> getting? That way we can help you figure out what you're doing wrong
> rather than just give you an answer.
>
> Michael Glaesemann

SELECT substring(data_field from '<name>(.)</name>')
FROM myTable

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly