The following bug has been logged on the website:
Bug reference: 16826
Logged by: James Inform
Email address: [hidden email]
PostgreSQL version: 13.1
Operating system: Mac and Ubuntu
Hopefully I am not messing up regex syntax, but it seems that handling of
non-greedy is not correct in substring function's regex.
When I set the non-greedy operator ? inside a regex in the substring
function, everything after the ? seems to be also treated as non-greedy,
which is wrong.