On Thu, 2012-01-26 at 20:43 -0500, Tom Lane wrote:
> Jeff Davis writes:
> > => select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE
> > count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ;
> > ERROR: cannot extract attribute from empty tuple slot
>
> I believe this
Jeff Davis writes:
> In REL8_4_STABLE and REL9_0_STABLE:
> => select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE
> count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ;
> ERROR: cannot extract attribute from empty tuple slot
I believe this is the same case fixed h
In REL8_4_STABLE and REL9_0_STABLE:
=> select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE
count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ;
ERROR: cannot extract attribute from empty tuple slot
A different error appears in 9.1.0 ("could not find pathkey item t