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