UNION and array types - Mailing list pgsql-general

From Eric B.Ridge
Subject UNION and array types
Date
Msg-id 6EE839C8-FE61-11D6-AC2D-0003937E3354@tcdi.com
Whole thread Raw
Responses Re: UNION and array types  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
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 by date:

Previous
From: Frank Bax
Date:
Subject: index vs seqscan question
Next
From: Bruno Wolff III
Date:
Subject: Re: UNION and array types