Contains and Contained operators

Open
#340 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
csharp, postgresql
Domain
api

Research direction

The issue names no source files or tests; start by locating the C# client code that currently handles the @> and <@ operators for Range values. Compare its request generation with the PostgreSQL Array, geometric, and JSON examples in the issue, and consider the work done when those supported types produce successful requests covered by tests.

Written by the indexing model from the issue text.

Description

area: postgrest feature

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 supabase-community/postgrest-csharp#15

Describe the solution you'd like

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

Dominant language
C#
Stars
701
Forks
106
Avg merge
16h 35m
Merged PRs (30d)
45

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from supabase/supabase-csharp

All issues in supabase/supabase-csharp

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.