[
https://issues.apache.org/jira/browse/CALCITE-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532721#comment-17532721
]
Chunwei Lei commented on CALCITE-5125:
--------------------------------------
BTW, PostgreSQL supports different kinds of concatenation[1], including:
1) array-to-array concatenation: ARRAY[1,2,3] || ARRAY[4,5,6]
2) array-to-array concatenation: ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9]]
3) element-to-array concatenation: 3 || ARRAY[4,5,6]
4) array-to-element concatenation: ARRAY[4,5,6] || 7
. Do you intend to support all of them?
[1] https://www.postgresql.org/docs/9.1/functions-array.html
> Extend "||" operator to work with arrays
> ----------------------------------------
>
> Key: CALCITE-5125
> URL: https://issues.apache.org/jira/browse/CALCITE-5125
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Dmitry Sysolyatin
> Assignee: Dmitry Sysolyatin
> Priority: Major
> Labels: pull-request-available
>
> "||" operator can be used only for string concatenation but it would be good
> to use it also for array concatenation as PostgreSQL
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
