On Thu, 2007-08-23 at 19:08 -0700, Postgres User wrote:
> On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> >
> > On Aug 23, 2007, at 20:01 , Postgres User wrote:
> >
> > >>> Yes, I read the manual. I think I had a problem because of the
> > >>> special chars (< / >) that I'm trying to s
On Aug 23, 2007, at 21:08 , Postgres User wrote:
You're right, that was a typo, I didn't copy and paste.
I found the problem, I was using 2 forward slashes instead of a
backslash + forward slash when pattern matching. The correct regex to
extract my substring:
substring(data_field from '(.+)<
On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 23, 2007, at 20:01 , Postgres User wrote:
>
> >>> 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 Aug 23, 2007, at 20:01 , Postgres User wrote:
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 ca
> > 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
[Please don't top post as it makes the discussion more difficult to
follow, and please reply to the list so that others may benefit from
and participate in the discussion.]
On Aug 23, 2007, at 19:49 , Postgres User wrote:
Yes, I read the manual. I think I had a problem because of the
speci
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 <[EMAIL PROTECTED]> wrote:
>
> On Aug 23, 2007, at 19:33 , Postgres User wrote:
>
> > I'm new to Regex in Postg
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 ''and '' in
a field?
Check out regexp_replace:
http://www.postgresql.org/docs/8.2/interactive/functions-
matching.html#FUNCTION
