Window function bug

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Window function bug
Date: 2011-07-12 00:48:06
Message-ID: 1310431686.497.26.camel@jdavis-ux.asterdata.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

In branch postgresql/master:

SELECT SUM(SUM(a)) OVER ()
FROM (SELECT NULL::int4 AS a WHERE FALSE) R;

ERROR: XX000: cannot extract attribute from empty tuple slot

Honestly, I'm not sure what the semantics of that are supposed to be. Is
it even allowed by the standard?

Regards,
Jeff Davis

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2011-07-12 01:03:53 Re: application_name appears in Reporting and logging
Previous Message Bruce Momjian 2011-07-12 00:41:47 Re: BUG #6085: pg_upgrade fails when unix_socket_directory != /tmp