Juhan-Peep Ernits <[EMAIL PROTECTED]> writes:
> (select id, mystuff from arraytest where id=1) union (select id, mystuf
> f from arraytest where id=2);
> ERROR: Unable to identify an ordering operator '<' for type '_varchar'
> Use an explicit ordering operator or modify the query
> Is
Hello!
The example is the following:
create table arraytest ( id int, mystuff varchar(40)[][]);
insert into arraytest values (1,'{{"a","b"}}');
insert into arraytest values (2,'{{"c","d"}}');
(select id, mystuff from arraytest where id=1) union (select id, mystuf
f from arraytest where id=2
