UNION and array types

Поиск
Список
Период
Сортировка
Искать
От
Eric B.Ridge
Тема
UNION and array types
Дата
Msg-id
6EE839C8-FE61-11D6-AC2D-0003937E3354@tcdi.com
Список
Дерево обсуждения
UNION and array types Eric B.Ridge <ebr@tcdi.com>
Re: UNION and array types Bruno Wolff III <bruno@wolff.to>
Re: UNION and array types Eric B.Ridge <ebr@tcdi.com>
UNIONs don't appear to work when you are trying to union 2 tables that 
include array types.
Example:
create table foo (bar int8[]);
insert into foo (bar) values ('{1,2,3}');
select * from foo union select * from foo;
ERROR:  Unable to identify an ordering operator '<' for type 'bigint[]'
         Use an explicit ordering operator or modify the query

Is it possible to make this work?  Please tell me yes.  :)

eric

В списке pgsql-general по дате отправления
От: Frank Bax
Дата:
Сообщение: index vs seqscan question
От: Bruno Wolff III
Дата:
Сообщение: Re: UNION and array types
FAQ