Re: [HACKERS] _text problem in union

Bruce Momjian wrote:
>
> > abil=> select '{"aaa"}'::_text union select '{"bbb"}'::_text;
> > ERROR: Unable to identify an ordering operator '<' for type '_text'
> > Use an explicit ordering operator or modify the query
> > abil=>
>
> Good problem description. Seems we can't compare arrays of text fields.
>
> Seems if we have an array of text fields, we could compare each element
> one-by-one using the base type until we get a comparison result.
>
> Not sure if this should make the TODO list or not.

It woulf be better to have a generic array compare op, that just
traverses
both arrays comparing them with the "<" for base type

--------------
Hannu