hydradatabase / hydradatabase/pg_stringtheory
feat: stringtheory.like(haystack text, search text) -> boolean
Open
- Dominant language
- C++
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
This is a possible proposal to implement:
`stringtheory.like(haystack text, search text) -> boolean`
The implementation would only optimize only if search text is either: `%foo%` (substring), `%foo` (suffix), or `foo%` (prefix) search. Otherwise the implementation would fall back to the Postgres built-in `LIKE` search automatically.
Possible gotchas:
* `%_foo%` would not be supported, since `_` means "matches any 1 character"
* `%\_foo%` is supported, since the backslash escapes the `_`.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.