To create a zero-argument aggregate function, write * in place of the list of argument specifications. (An example of such an aggregate is count (*) .) base_type. In the old syntax for CREATE AGGREGATE, the input data type is specified by a basetype parameter rather than being written next to the aggregate name.