Re: How to extract a substring using Regex - Mailing list pgsql-general

From Postgres User
Subject Re: How to extract a substring using Regex
Date
Msg-id b88c3460708231801k51dcbad3nbd6c45c3fb7418c8@mail.gmail.com
Whole thread Raw
In response to Re: How to extract a substring using Regex  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: How to extract a substring using Regex  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
> > 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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: How to extract a substring using Regex
Next
From: Ron Johnson
Date:
Subject: Re: Geographic High-Availability/Replication