search

supabase / pg_graphql

GraphQL support for PostgreSQL
https://supabase.github.io/pg_graphql
Apache License 2.0
2.88k stars 101 forks source link

Add is: null, not null filter operator to array filter #527

Closed leefordjudes closed 3 months ago

leefordjudes commented 3 months ago

Describe the bug kindly Add is: null, not null filter operator to array filter,

i saw pg_graphql 1.5.5 has [ cd, cs, eq, gt, gte, lt, lte, neq, ov] these filters. need to check is null and is not null.

Versions:

olirice commented 3 months ago

thanks for catching the absent is support. I'll open a PR for it

gt, gte, lt, lte, neq were actually removed because their function is a bit postgres specific i.e. there is no agreed upon set of rules across programming languages to determine if one array is greater than another array.

leefordjudes commented 3 months ago

Thank you for adding IS filtering support, because i need it for my task. kindly release as soon as possible.

olirice commented 3 months ago

working on it here https://github.com/supabase/pg_graphql/pull/529

expecting to have an official release out Monday or Tuesday