"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Tue, Apr 25, 2017 at 9:26 AM, Mike Blackwell <mike.blackwell@xxxxxxx> > wrote: >> The docs (section 9.18 for PG 9.6) show as an example for array >> concatenation >> ARRAY[4,5,6] || 7 >> which works fine. However, trying the same with an array of text doesn't >> work: >> # select array['a','b','c'] || 'd'; >> ERROR: malformed array literal: "d" >> >> The assumption that the second argument is an array constant seems >> surprising > It has to assume something. And for better and worse it has to assume it > without looking at the actual value. Yeah. The core problem here is that the parser has to disambiguate the || operator: is it "anyarray || anyelement" or "anyarray || anyarray"? In your first example the array can be seen to be int[] and 7 is taken to be type int, so only "anyarray || anyelement" works. In the second case it's looking at "int[] || unknown", and the relevant heuristic is to assume that the "unknown" is the same type as the operator's other input. Peeking at the contents of the literal would make the behavior very unpredictable/data-dependent, so we don't. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
