Re: push array to array

2016-09-18 19:15 GMT+02:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

>
>
> 2016-09-18 19:12 GMT+02:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
>
>> Hi
>>
>>
>> 2016-09-18 18:46 GMT+02:00 Tjibbe <tjibbe(at)rijpma(dot)org>:
>>
>>> '{{4,5},{8,3}}' + '{3,6}'
>>
>>
>> postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]];
>> +---------------------+
>> | ?column? |
>> +---------------------+
>> | {{4,5},{8,3},{3,6}} |
>> +---------------------+
>> (1 row)
>>
>
> CREATE OR REPLACE FUNCTION public.array2d_append(integer[], integer[])
> RETURNS integer[]
> LANGUAGE sql
> AS $function$
> SELECT COALESCE($1 || ARRAY[$2], $1, $2);
> $function$
>

sorry

better

SELECT COALESCE($1 || ARRAY[$2], $1, ARRAY[$2]);

>
> postgres=# SELECT array2d_append('{{4,5},{8,3}}', '{3,6}');
> +---------------------+
> | array2d_append |
> +---------------------+
> | {{4,5},{8,3},{3,6}} |
> +---------------------+
> (1 row)
>
>
>
>>
>> regards
>>
>> Pavel
>>
>
>