Re: Over-optimization in ExecEvalWholeRowVar

On Fri, Jul 11, 2014 at 2:43 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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: record type has not been registered

Thanks Tom!

If anybody gets hit by this, the workaround I use is to put the inner
subquery as a CTE:

select (
select q from
(
with data as (
select 1,2,3 where f1>0
union all
select 4,5,6.0 where f1<=0
)
select * from data
) q
)
from int4_tbl;

merlin