• T
    My first chosen victim for expression_tree_walker conversion · e7865086
    Tom Lane 提交于
    is parse_aggs.c.  This fixes its failure to cope with (at least) CaseExpr
    and ArrayRef nodes, which is the reason why both of these fail in 6.5:
    select coalesce(f1,0) from int4_tbl group by f1;
    ERROR:  Illegal use of aggregates or non-group column in target list
    select sentence.words[0] from sentence group by sentence.words[0];
    ERROR:  Illegal use of aggregates or non-group column in target list
    The array case still fails, but at least it's not parse_agg's fault
    anymore ... considering that we now support CASE officially, I think
    it's important to fix the first example ...
    e7865086
parse_agg.c 10.3 KB