BUG #6202: type of union column selection bug

From: "Roman" <zotov(at)oe-it(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6202: type of union column selection bug
Date: 2011-09-10 01:41:40
Message-ID: 201109100141.p8A1fe5s038019@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6202
Logged by: Roman
Email address: zotov(at)oe-it(dot)ru
PostgreSQL version: 9.0.4
Operating system: Win7x64
Description: type of union column selection bug
Details:

Query
select null union select 4
is Ok but
select null union select null union select 4
is Fail

i think it`s a bug because you choose type in second query twice
null and null -> text
text and int -> fail

and i think what check type category is not true, because i can`t create
implicit cast to resolve some problems, like
select 'a' union select 4
if i have implicit cast int->text i think it must work!!

Sorry second part is not bug it`s a feature but it`s my problem too

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thom Brown 2011-09-11 00:35:11 Dropped index on table preventing rule creation
Previous Message Craig Ringer 2011-09-10 00:53:13 Re: BUG #6201: Windows User Log Off Causes Backend Exception 0xC0000142