Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Add array expressions #6075

Closed
bubbajoe opened this issue Apr 20, 2023 · 2 comments · Fixed by #6384
Closed

Add array expressions #6075

bubbajoe opened this issue Apr 20, 2023 · 2 comments · Fixed by #6384
Labels
enhancement New feature or request

Comments

@bubbajoe
Copy link

Is your feature request related to a problem or challenge?

Hello,

I have an array data type and i would like to be able to run the following functions.

Describe the solution you'd like

array_length(col)
array_contains(col, T) AND/OR select * from my_table where 'text'=ANY(my_col);
array_unnest()

# TABLE
| food | ingredients          |
| ---- | -------------------- |
| user | [eggs, salt, pepper] |

# SQL INPUT
# SELECT food, unnest(ingredients) from TABLE

# SQL OUTPUT
| food | unnest(ingredients) |
| ---- | ------------------- |
| user | eggs                |
| user | pepper              |
| user | salt                |

Describe alternatives you've considered

No response

Additional context

No response

@bubbajoe bubbajoe added the enhancement New feature or request label Apr 20, 2023
@bubbajoe bubbajoe changed the title Add array expressiona Add array expressions Apr 21, 2023
@izveigor
Copy link
Contributor

Hello, @bubbajoe!
I have created the separate issue dedicated the implementation of the missing functions and operations for working with arrays: #6119

@bubbajoe
Copy link
Author

bubbajoe commented Apr 25, 2023

@izveigor can you also add AnyOp design for checking if an item is in the array?

Example: 'select * from my_table where 'text'=ANY(my_col);'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants