On 01/12/15 00:59, Bruce Momjian wrote:
I would argue that '{}'::int[] is zero dimmensions, so there is no
documented behavior for this.
Thank you for your reply. Agree, I am writing to pgsql-docs because I
think this should be fixed with proper documentation.
My actual concern is that it is
I just got confused by another behavior of the || operator. I thought it
might be appropriate to report it here.
The docs say "the result retains the lower bound subscript of the
left-hand operand’s outer dimension" [1]. That's again not true for
corner cases.
Expected:
# SELECT '{0}'::int[]
Hi,
On 07/09/2015 04:00 PM, Tom Lane wrote:
Hm. I don't think there is really room for such an example in that table,
and certainly not room for a discursive discussion. What would make more
sense to me is to add a paragraph and example concerning this issue at the
bottom of section 8.15.4, ri
A few minutes ago I got bitten by the following PostgreSQL (9.4) behavior
SELECT ARRAY[1] || NULL, array_append(ARRAY[1], NULL);
?column? | array_append
--+--
{1} | {1,NULL}
I expected that array_append and || are equivalent in this case but
obviously they are not. Su
