• Tom Lane's avatar
    Support the syntax · 3651a3e6
    Tom Lane authored
    	CREATE AGGREGATE aggname (input_type) (parameter_list)
    along with the old syntax where the input type was named in the parameter
    list.  This fits more naturally with the way that the aggregate is identified
    in DROP AGGREGATE and other utility commands; furthermore it has a natural
    extension to handle multiple-input aggregates, where the basetype-parameter
    method would get ugly.  In fact, this commit fixes the grammar and all the
    utility commands to support multiple-input aggregates; but DefineAggregate
    rejects it because the executor isn't fixed yet.
    I didn't do anything about treating agg(*) as a zero-input aggregate instead
    of artificially making it a one-input aggregate, but that should be considered
    in combination with supporting multi-input aggregates.
    3651a3e6
create_aggregate.sgml 12 KB