From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 02:06:07 |
Message-ID: | 1327629967.9123.4.camel@sussancws0025 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, 2012-01-26 at 20:43 -0500, Tom Lane wrote:
> Jeff Davis <pgsql(at)j-davis(dot)com> 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 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.
Thank you. For the record, it looks like the one that fixed the similar
problem in early 9.1 was here:
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-01-27 06:37:11 | Re: pgcrypto decrypt_iv() issue |
Previous Message | Tom Lane | 2012-01-27 01:43:04 | Re: 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions |