Viktor Rosenfeld <listuser36@xxxxxxxxxxxxxx> writes: > annis=> select array_agg(array['a'::varchar, 'b', 'c']); > ERROR: could not find array type for data type character varying[] > Why doesn't this work? The output of array_agg would have to be an array whose elements are array-of-varchar. Which is a datatype we don't have. (2-D array is a different concept...) 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