Re: BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work
Дата
Msg-id 23718.1323056406@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work  (Maxim Boguk <maxim.boguk@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
Maxim Boguk <maxim.boguk@gmail.com> writes:
> PS: I try create two-dimentional integer array from  query results:

Well, you could do that with a suitably defined aggregate having the
signature "agg(anyarray) returns anyarray".  But array_agg has the
signature "array_agg(anyelement) returns anyarray" so you can't use
it on an array input.  2-D arrays are not distinct from 1-D arrays
so far as the type system is concerned.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Re: BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work
Следующее
От: Noah Misch
Дата:
Сообщение: Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs