| 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: | Whole Thread | Raw Message | 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
| 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 |