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

unable to search on citext columns #2222

Open
wysher opened this issue Jan 12, 2025 · 1 comment
Open

unable to search on citext columns #2222

wysher opened this issue Jan 12, 2025 · 1 comment
Labels

Comments

@wysher
Copy link

wysher commented Jan 12, 2025

In my database, I have an email column which is of CITEXT type.

I'm using a TypeScript client to search with a WHERE clause like:

{ where: `email = '[email protected]'` }

and I'm getting an error:

{"where":["At location 6: Could not select an operator overload"]}

I've also tried with other operators: LIKE, ILIKE, etc.

I'm assuming there is an issue with CITEXT because when I changed the email to type text, the issue goes away. But I'd still like to use CITEXT ;)

@balegas
Copy link
Contributor

balegas commented Jan 13, 2025

CITEXT is not supported atm. Sorry you stumbled into this. We're going to look into it.

@balegas balegas added the bug label Jan 13, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants