Re: BUG #19104: Does regexp_substr function support non-greedy matching?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: zoulx1982@163.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-11-05T14:49:56Z
Lists: pgsql-bugs
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