BUG #7644: Missing implicit types of Result and failing type-conversion

From: rep(dot)dot(dot)nop(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7644: Missing implicit types of Result and failing type-conversion
Date: 2012-11-09 09:57:45
Message-ID: E1TWlLN-0001Kk-0p@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7644
Logged by: Bernhard Reutner-Fischer
Email address: rep(dot)dot(dot)nop(at)gmail(dot)com
PostgreSQL version: 9.1.6
Operating system: debian
Description:

Hi,

According to
http://www.postgresql.org/docs/9.1/static/typeconv-union-case.html

i think that these 2 (separate?) issues are bugs(?)
1)
select distinct on (bug) bug
from (
select * from (select 'string one' AS bug from generate_series(0,1))
s1
UNION
select * from (select 'string two' bug from generate_series(0,0))
s2
) x
;
ERROR: could not determine which collation to use for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.

When casting the return value of the union to :text _explicitly_ it works as
expected:
select distinct on (bug) bug
from (
select * from (select 'string one'::text AS bug from
generate_series(0,1)) s1
UNION
select * from (select 'string two' bug from generate_series(0,0))
s2
) x
;
bug
------------
string one
string two
(2 rows)

2)
select distinct on (bug) bug
from (
select * from (select 'string one' AS bug from generate_series(0,1))
s1
UNION
select * from (select 'string two' bug) s2
) x
;
ERROR: failed to find conversion function from unknown to text

In this case, however, using a "Result" fails to implicitly typecast to
:text, i.e. casting the return value of the first return value of the union
to :text explicitly does _not_ work:

select distinct on (bug) bug
from (
select * from (select 'string one'::text AS bug from
generate_series(0,1)) s1
UNION
select * from (select 'string two' bug ) s2

) x
;
ERROR: failed to find conversion function from unknown to text

What am i missing or doing wrong?
thanks and cheers,

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message daniel 2012-11-09 22:49:33 BUG #7648: Momentary index corruption while in hot standby
Previous Message Amit Kapila 2012-11-09 06:03:32 Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown