BUG #12625: operation 'union' confirms the type of the column with 2 unknown types.

From: yuanchongwei007(at)163(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12625: operation 'union' confirms the type of the column with 2 unknown types.
Date: 2015-01-22 05:02:30
Message-ID: 20150122050230.32673.52053@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: 12625
Logged by: Chongwei Yuan
Email address: yuanchongwei007(at)163(dot)com
PostgreSQL version: 9.3.5
Operating system: Ubuntu 14.04.1 LTS
Description:

1. exce sql [ select 'abc' as col ] ; result : column 'col' has unknow
type.
2. exce sql [ select 'def' as col ] ; result : column 'col' has unknow
type.
But
3. exce sql [ select 'abc' as col union select 'def' as col ] ; result :
colum 'col' has text type.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Asif Naeem 2015-01-22 07:07:00 Re: pg_upgrade failure on Windows Server
Previous Message Michael Paquier 2015-01-22 04:38:02 Re: pg_upgrade failure on Windows Server