Tom Lane wrote:
Pavel Stehule <[EMAIL PROTECTED]> writes:
Is possible merge two arrays like
array[1,2,3] + array[4,5,6] => array[1,2,3,4,5,6]
I was about to say that || would do it, but I see that's not quite
right:
regression=# SELECT ARRAY[1,2,3] || ARRAY[4,5,6];
?column?
Joe Conway <[EMAIL PROTECTED]> writes:
> Hmmm, it made sense to me, at at least at some point ;-). Here's the
> SQL99 guidance (SQL200X doesn't give any more detailed guidance):
> 4.11.3.2 Operators that operate on array values and return array values
> is an operation that returns the array val
Pavel Stehule <[EMAIL PROTECTED]> writes:
> Is possible merge two arrays like
> array[1,2,3] + array[4,5,6] => array[1,2,3,4,5,6]
I was about to say that || would do it, but I see that's not quite
right:
regression=# SELECT ARRAY[1,2,3] || ARRAY[4,5,6];
?column?
---
{{1,2,3}
Hello,
Is possible merge two arrays like
array[1,2,3] + array[4,5,6] => array[1,2,3,4,5,6]
select array_append(array[1,2,3], array[2,3]);
ERROR: function array_append(integer[], integer[]) does not exist
regards
Pavel Stehule
---(end of broadcast)---
