Request a Demo
Home   >   mailing lists

Re: BUG #19104: Does regexp_substr function support non-greedy matching? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19104: Does regexp_substr function support non-greedy matching?
Date
Msg-id 812834.1762354196@sss.pgh.pa.us
Whole thread Raw
In response to BUG #19104: Does regexp_substr function support non-greedy matching?  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
PG Bug reporting form <noreply@postgresql.org> writes:
> When i use regexp_substr to process some text file, i found regexp_substr
> does not support non-greedy match.

Sure it does.  But the details of the behavior are different from
Perl's engine in cases where you have both greedy and non-greedy
quantifiers (as your example does).  Read the greediness rules here:

https://www.postgresql.org/docs/current/functions-matching.html#POSIX-MATCHING-RULES

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns
Next
From: "Haiyang Li"
Date:
Subject: Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors