Re: [BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to windowfunctions

#1

On Thu, 2012-01-26 at 20:43 -0500, Tom Lane wrote:

Quote:

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=...ff;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:

http://git.postgresql.org/gitweb/?p=...ad07828df281d9

Regards,
Jeff Davis

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to windowfunctions

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to windowfunctions - 01-26-2012 , 08:06 PM