Status 400 when attempting to query by array value

[luisw90]

Bug report

Describe the bug

Status 400 when attempting to query by array value

For example:

• Making a query for all works.

.from("posts").select(columns: "*").execute().value

• But making a query by array value gives a unacceptableStatusCode(400)

.from("posts").select(columns: "*").contains(column: "members", value: userid).execute().value

To Reproduce

Crate a table, RLS policy and query by array value

• Table name: posts
• Table column name: "members"
• Column array: [userid1, userid2, userid3]

Expected behavior

Should either return an empty array or results

System information

OS: macOS Ventura 13.3
Version of supabase-ios: 0.2.1

[workbytaylor]

I saw your post on Stack Overflow, and noticed the same error occurs when using .overlaps() instead of .contains(). Thanks for creating an issue - hopefully it's resolved soon.

For example:

.from("posts")
.select()
.overlaps(column: "column", value: "value")
.execute().value

[grdsdev]

Hey @luisw90 I've added this case on the integration tests of postgrest-swift library, and I was able to make it work.

The value parameter has to be an Array as the underlying Postgres type is an array.

Please check this PR #45, if you still have an issue let me know.