Skip to content

Array containment operator #6884

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom
Closed
2 tasks
izveigor opened this issue Jul 7, 2023 · 0 comments · Fixed by #6885
Closed
2 tasks

Array containment operator #6884

izveigor opened this issue Jul 7, 2023 · 0 comments · Fixed by #6885
Labels
enhancement New feature or request

Comments

@izveigor
Copy link
Contributor

izveigor commented Jul 7, 2023 •
edited
Loading

Is your feature request related to a problem or challenge?

Like other popular databases (DuckDB, PostgreSQL) it would be better to support some operators for working with arrays, making life easier for the user. The most popular operator is array containment operator which check a subset belongs to a set (in other words, the operator is alias of array_has_all function).

There are two options:

  • @> (equals to array_has_all(array1, array2)
  • <@ (equals to array_has_all(array2, array1)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: array containment operator @> and <@
1 participant
@izveigor