Re: UNION and array types

On Fri, Nov 22, 2002 at 16:29:07 -0500,
"Eric B. Ridge" <ebr(at)tcdi(dot)com> wrote:
> 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. :)

I think you can get by with union all if you don't care if duplicates stay.