Contains filter @>

[elrhomariyounes]

Bug report

Describe the bug

Hello, as @acupofjose mentioned in #16 postgrest seems to not recognize the operator. I went to read the docs and I found out that this operator is used in this cases

• Array types

ARRAY[1,4,3] @> ARRAY[3,1,3]

• Range types

int4range(2,4) @> int4range(2,3)

• Geometric types

circle '<(0,0),2>' @> point '(1,1)'

• Json

'{"a":1, "b":2}'::jsonb @> '{"b":2}'::jsonb

So I give a first try with ranges. I I encountered several issues.

1. An exceptionthrown in the QueryFilter constructor because not allowing a range criteria and contains filter operator, I solved it by adding the operator to the switch case
2. After solving 1. a request exception by Postgrest the url was not formed correctly after debugging the range criteria was not added by the PrepareFilter method in Table class. I fixed by correctly formatting the url if a range criteria is the case please check PR ☺️

I would love to check the others cases.

To Reproduce

var filteredResponse = await client.Table<User>().Filter("age_range", Operator.Contains, new Range(1,2)).Get(); 

Expected behavior

• Get a filtered response all the users with age range in the criteria

System information

-OS: [Windows 10 Pro 1909]
-.Net core 3.1.x
-Visual Studio 16.8
-Version of supabase-postgrest-csharp: master branch of current repo

[elrhomariyounes]

@acupofjose we can close this issue and open another one for contains and contained operators.

Range criteria is solved in #19 and #21. Still to solve array and json types.