Re: [BUGS] BUG #6626: union all with values of type unknown

2012-05-22 Thread Robert Haas
On Thu, May 3, 2012 at 9:01 PM, w...@heroku.com wrote: The following bug has been logged on the website: Bug reference:      6626 Logged by:          Will Leinweber Email address:      w...@heroku.com PostgreSQL version: 9.1.3 Operating system:   ubuntu 10.04 Description: This was

Re: [BUGS] BUG #6626: union all with values of type unknown

2012-05-22 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: deik3qfhu265n6= with hello as (select 'hello' as name) deik3qfhu265n6- , bye as (select 'bye' as name) deik3qfhu265n6- select * from hello UNION ALL select * from bye; ERROR:  failed to find conversion function from unknown to text I think it should

Re: [BUGS] BUG #6626: union all with values of type unknown

2012-05-22 Thread Robert Haas
On Tue, May 22, 2012 at 3:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: deik3qfhu265n6= with hello as (select 'hello' as name) deik3qfhu265n6- , bye as (select 'bye' as name) deik3qfhu265n6- select * from hello UNION ALL select * from bye; ERROR:  failed

Re: [BUGS] BUG #6626: union all with values of type unknown

2012-05-22 Thread Pavel Stehule
2012/5/22 Robert Haas robertmh...@gmail.com: On Tue, May 22, 2012 at 3:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: deik3qfhu265n6= with hello as (select 'hello' as name) deik3qfhu265n6- , bye as (select 'bye' as name) deik3qfhu265n6- select * from hello

[BUGS] BUG #6626: union all with values of type unknown

2012-05-04 Thread will
The following bug has been logged on the website: Bug reference: 6626 Logged by: Will Leinweber Email address: w...@heroku.com PostgreSQL version: 9.1.3 Operating system: ubuntu 10.04 Description: This was surprising because it worked without the UNION ALL. Casting