@sql-extra/alter-aggregate v0.1.8

Change the definition of an aggregate function (ALTER AGGREGATE).

const alterAggregate = require('@sql-extra/alter-aggregate');
// alterAggregate.renameTo(<name>, <signature>, <new_name>)
// alterAggregate.ownerTo(<name>, <signature>, <new_owner>)
// alterAggregate.setSchema(<name>, <signature>, <new_schema>)
// -> SQL query


alterAggregate.renameTo('myavg', 'INTEGER', 'my_average');
// ALTER AGGREGATE "myavg" (INTEGER) RENAME TO "my_average";

alterAggregate.ownerTo('mypercentile', 'FLOAT8 ORDER BY INTEGER', 'jaipur');
// ALTER AGGREGATE "myavg" (FLOAT8 ORDER BY INTEGER) OWNER TO "jaipur";

alterAggregate.setSchema('mypercentile', 'FLOAT8, INTEGER', 'myschema');
// ALTER AGGREGATE "mypercentile" (FLOAT8, INTEGER) SET SCHEMA "myschema";