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

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

pgsql-bugs by date

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

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