Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Postgres LIKE operators #8893

Closed
gruuya opened this issue Jan 17, 2024 · 0 comments · Fixed by #8894
Closed

Add support for Postgres LIKE operators #8893

gruuya opened this issue Jan 17, 2024 · 0 comments · Fixed by #8894
Labels
enhancement New feature or request

Comments

@gruuya
Copy link
Contributor

gruuya commented Jan 17, 2024

Is your feature request related to a problem or challenge?

Add support for the operators ~~, ~~*, !~~, !~~*, which are short-hand for LIKE, ILIKE, NOT LIKE and NOT ILIKE respectively, since they are currently missing.

Describe the solution you'd like

I've opened a sqlparser-rs PR to enable parsing of these tokens into operator enums: apache/datafusion-sqlparser-rs#1096

Ideally we'd then just extend the Operator enum to encompass the new variants, and add evaluation for them like for other binary operators.

Describe alternatives you've considered

Rewriting Postgres queries/ASTs to map the operators into the verbatim LIKE expressions.

Additional context

No response

@gruuya gruuya added the enhancement New feature or request label Jan 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant