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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026