On Fri, Jul 11, 2014 at 2:43 PM, Tom Lane wrote:
> This example in the regression database is a simplified version of a bug
> I was shown off-list:
>
> regression=# select (
> select q from
> ( select 1,2,3 where f1>0
> union all
> select 4,5,6.0 where f1<=0
> ) q
> )
> from int4_tbl;
> ERROR:
This example in the regression database is a simplified version of a bug
I was shown off-list:
regression=# select (
select q from
( select 1,2,3 where f1>0
union all
select 4,5,6.0 where f1<=0
) q
)
from int4_tbl;
ERROR: record type has not been registered
The reason for the problem is that