postgrest-csharp icon indicating copy to clipboard operation
postgrest-csharp copied to clipboard

Contains and Contained operators

Open elrhomariyounes opened this issue 5 years ago • 0 comments

Feature request

Is your feature request related to a problem? Please describe.

Hello, the contains (@>) and contained (<@) operators only supports for now Range types. In the docs they can be used also with Array types, Geometric types and Json

ARRAY[1,4,3] @> ARRAY[3,1,3]
ARRAY[2,2,7] <@ ARRAY[1,7,4,2,6]
circle '<(0,0),2>' @> point '(1,1)'
point '(1,1)' <@ circle '<(0,0),2>'
'{"a":1, "b":2}'::jsonb @> '{"b":2}'::jsonb
'{"b":2}'::jsonb <@ '{"a":1, "b":2}'::jsonb

I think when using List the Postgrest the request failed, doesn't recognize the operator as @acupofjose mentioned in #15

Describe the solution you'd like

If you can support those types specially arrays. Thank you very much.

elrhomariyounes avatar Dec 10 '20 06:12 elrhomariyounes