>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Further experimentation reveals that this change has the effect of>> blocking constant-folding in aggregate input
expressionsthat refer>> to constant outputs of the subquery. Is it worth doing anything>> about that?
Tom> Uh ... but I thought the point here is that the outputs aren'tTom> really constant in the presence of grouping
sets.
select x, y, sum(z) from (select 1 as x, 2 as y, 3 as z) sgroup by grouping sets (x,y);
x and y aren't constants, but z is.
--
Andrew (irc:RhodiumToad)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs