Skip site navigation (1) Skip section navigation (2)

Re: 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions
Date: 2012-01-27 01:43:04
Message-ID: 16536.1327628584@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Jeff Davis <pgsql(at)j-davis(dot)com> 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 here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c1d9579dd

and as noted in that commit message, it didn't appear worth the risk
of fixing it in released branches.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Jeff DavisDate: 2012-01-27 02:06:07
Subject: Re: 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions
Previous:From: Jeff DavisDate: 2012-01-27 00:06:31
Subject: 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group