Re: [HACKERS] _text problem in union

>
> Hi,
>
> I have small problem with text array in union query.. see:
>
>
> abil=> select 5 union select 5;
> ?column?
> --------
> 5
> (1 row)
>
> abil=> select 5 union select 6;
> ?column?
> --------
> 5
> 6
> (2 rows)
>
> abil=> select '{"aaa"}'::_text union select '{"aaa"}'::_text;
> ?column?
> --------
> {"aaa"}
> (1 row)
>
> 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.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026