Tracking: array functions & operators

[lmatz]

https://www.postgresql.org/docs/current/functions-array.html

A significant difference between PostgreSQL array and RisingWave array/list is that the former requires multi-dimensional ones to be rectangular (like in C), while the latter allows jagged ones (like vector or list). See #3811 (comment)

proto ExprType 531..=559

Array Access

• implement accessing arrays by range of indexes #9357

Array Dimensions

• implement array_dims
• implement array_ndims feat: implement array_ndims #8881
• implement array_length feat: Add support for array_length function in psql #8636
• implement array_lower
• Support array_upper function #8201
• implement cardinality feat: cardinality array function #8854

Array consumption

• feat: support array containment @>, <@ #13180
• array overlap &&
• implement array_position
• implement array_positions #9151
• implement array_to_string (aka array_join) #7764

Array Construction and Mutation

• array_cat, array_prepend, array_append, ||
• implement array_remove #9114
• implement array_replace Improve array_replace for more element types #10168
• implement trim_array #9264
• implement array_fill
• implement array_distinct #7765

ScalarArrayOp

• feat: add ANY/ALL/SOME(array) operator to support get_indexes in sqlalchemy #6717

Aggregation

• implement array_agg #7763

Set Returning Function

• feat: support unnest function #3017
• support function generate_subscripts #11575

[fuyufjh]

cc. @xiangjinwu is also working on struct & array recently

[kamalesh0406]

Hi @fuyufjh @lmatz , have all these array operations been implemented? I can contribute the functions if no one is looking into them. Thanks!

[lmatz]

Hi @fuyufjh @lmatz , have all these array operations been implemented? I can contribute the functions if no one is looking into them. Thanks!

Hi @kamalesh0406, sure, thank you! Feel free to work on the ones that you are interested in.

Please be cautious about (see also #3811)

A significant difference between PostgreSQL array and RisingWave array/list is that the former requires multi-dimensional ones to be rectangular (like in C), while the latter allows jagged ones (like vector or list).`

[kamalesh0406]

Sure :), I will start with array_length since it seems trivial.

[kamalesh0406]

I am working on adding array_remove in a separate PR. Just mentioning it so that there is no duplicate effort :) .

[BanBuDu0]

Hi all, may I take array_dims function?
I think this function is currently not assigned.

[lmatz]

Hi all, may I take array_dims function?

I think this function is currently not assigned.

Sure, thanks for your interests!

[kevinmingtarja]

Hi, I'd like to take array_fill! Mentioning it here so that there is no duplicate