You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Dumindu Buddhika (JIRA)" <ji...@apache.org> on 2015/07/06 16:29:04 UTC

[jira] [Updated] (PHOENIX-2101) Implement ARRAY_TO_STRING built in function

     [ https://issues.apache.org/jira/browse/PHOENIX-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dumindu Buddhika updated PHOENIX-2101:
--------------------------------------
    Description: 
ARRAY_TO_STRING(anyarray, text [, text]) - Concatenates array elements using supplied delimiter and optional null string and returns the resulting string

eg:
ARRAY_TO_STRING(ARRAY['1', '2, '3', NULL, '5'], ',', 'k') → '1,2,3,k,5'
ARRAY_TO_STRING(ARRAY[23, 34, 45], ',') → '23,34,45'

  was:
ARRAY_TO_STRING(anyarray, text [, text]) - Concatenates array elements using supplied delimiter and optional null string and returns the resulting string

eg:
ARRAY_TO_STRING(ARRAY['1', '2, '3', NULL, '5'], ',', '*') → '1,2,3,*,5'
ARRAY_TO_STRING(ARRAY[23, 34, 45], ',') → '23,34,45'


> Implement ARRAY_TO_STRING built in function
> -------------------------------------------
>
>                 Key: PHOENIX-2101
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2101
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Dumindu Buddhika
>            Assignee: Dumindu Buddhika
>
> ARRAY_TO_STRING(anyarray, text [, text]) - Concatenates array elements using supplied delimiter and optional null string and returns the resulting string
> eg:
> ARRAY_TO_STRING(ARRAY['1', '2, '3', NULL, '5'], ',', 'k') → '1,2,3,k,5'
> ARRAY_TO_STRING(ARRAY[23, 34, 45], ',') → '23,34,45'



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)