_text problem in union

From: Zakkr <zakkr(at)zf(dot)jcu(dot)cz>
To: pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: _text problem in union
Date: 1999-09-27 13:11:10
Message-ID: Pine.LNX.3.96.990927150619.8444A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

... hmm, any suggestion?

Zakkr

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-09-27 13:20:26 Re: [HACKERS] Frustration
Previous Message Olivier PRENANT 1999-09-27 12:09:46 Column crypt