could not find array type for data type text[] : 42704

[ib-8]

Describe the bug
Querying based on any value in a given array contains in a column of text[]. select().in_() method throws exception

Flutter Client
var result = await Supabase.instance.client
.from('my_table')
.select()
.in_('my_column', ['value']);

Exception
PostgrestException (PostgrestException(message: could not find array type for data type text[], code: 42704, details: Bad Request, hint: null))

[Vinzent03]

Please share the type of your column. I guess it's text[]. That's not how the in operator works. The column needs to be of type text.

I guess you are searching for @>, but take a look at the list of array operators and the conversion of these operators to postgrest

[ib-8]

Yes, the type is text[]. Sorry, I'm new to the sql/supabase world.
Closing the issue.
Thanks

[tiltmaster]

how did you solve this?

[ib-8]

query.in() is used to query for the "text" data type not "text[]".
For my use case, I used query.contains('fruits', [apple, grape]);

Reference: https://supabase.com/docs/reference/dart/contains