>>>>> "Andrew" == Andrew Gierth <and...@tao11.riddles.org.uk> writes: >>>>> "Jeevan" == Jeevan Chalke <jeevan.cha...@enterprisedb.com> writes:
Jeevan> Hi, Jeevan> While playing with LATERAL along with some aggregates in Jeevan> sub-query, I have observed somewhat unusual behavior. Andrew> Simpler example not needing LATERAL: Andrew> select array(select sum(x+y) from generate_series(1,3) y group by y) Andrew> from generate_series(1,3) x; Oh, and another way to verify that it's a bug and not expected behavior is that it goes away with set enable_hashagg=false; -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
