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 по дате отправления