search

nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.67k stars 117 forks source link

Cannot use .*? in regexp_replace #43

Closed LaurentDhont closed 2 years ago

LaurentDhont commented 2 years ago

When using .? in regexp_replace it fails with regexp(3): nested ?.

nalgeon commented 2 years ago

This extension does not support lazy quantifiers, and I have no plans to add it.

nalgeon commented 1 year ago

Lazy quantifiers are supported in the regexp extension starting with the 0.18 release:

sqlite> select regexp_substr('brave new world', '.*e');
brave ne

sqlite> select regexp_substr('brave new world', '.*?e');
brave