Re: could not find array type for data type character varying[] - Mailing list pgsql-general

From Tom Lane
Subject Re: could not find array type for data type character varying[]
Date
Msg-id 21332.1256743841@sss.pgh.pa.us
Whole thread Raw
In response to could not find array type for data type character varying[]  (Viktor Rosenfeld <listuser36@googlemail.com>)
List pgsql-general
Viktor Rosenfeld <listuser36@googlemail.com> 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

pgsql-general by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: could not find array type for data type character varying[]
Next
From: Alvaro Herrera
Date:
Subject: Re: auto truncate/vacuum full