UNION and array types

From: Eric B(dot)Ridge <ebr(at)tcdi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: UNION and array types
Date: 2002-11-22 21:29:07
Message-ID: 6EE839C8-FE61-11D6-AC2D-0003937E3354@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-22 21:50:25 Re: UNION and array types
Previous Message Frank Bax 2002-11-22 21:15:45 index vs seqscan question

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-22 21:50:25 Re: UNION and array types
Previous Message Josh Berkus 2002-11-22 19:43:50 Re: Need help with currval and nextvall...