Skip site navigation (1) Skip section navigation (2)

_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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-09-27 13:20:26
Subject: Re: [HACKERS] Frustration
Previous:From: Olivier PRENANTDate: 1999-09-27 12:09:46
Subject: Column crypt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group