Re: could not find array type for data type character varying[]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Viktor Rosenfeld <listuser36(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: could not find array type for data type character varying[]
Date: 2009-10-28 15:30:41
Message-ID: 21332.1256743841@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Viktor Rosenfeld <listuser36(at)googlemail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-28 15:36:07 Re: auto truncate/vacuum full
Previous Message JC Praud 2009-10-28 15:21:11 Re: auto truncate/vacuum full