Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> can anyone explain why
> SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1);
> returns 0 not 1
Because array_prepend keeps the subscripts of the existing array
elements the same. This was discussed during development of the
code, but I don't see anything in the documentation that mentions it.
regards, tom lane