Postgres Pro
Downloads
Home   >   mailing lists

BUG #12625: operation 'union' confirms the type of the column with 2 unknown types. - Mailing list pgsql-bugs

From yuanchongwei007@163.com
Subject BUG #12625: operation 'union' confirms the type of the column with 2 unknown types.
Date
Msg-id 20150122050230.32673.52053@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12625: operation 'union' confirms the type of the column with 2 unknown types.  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      12625
Logged by:          Chongwei Yuan
Email address:      yuanchongwei007@163.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.

pgsql-bugs by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: BUG #12628: range of sqlstate for user defined exception
Next
From: r.andom.dev4+postgres@gmail.com
Date:
Subject: BUG #12630: Postgres APT script issues