>
> 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