create_aggregate.out

来自「关系型数据库 Postgresql 6.5.2」· OUT 代码 · 共 15 行

QUERY: CREATE AGGREGATE newavg (
   sfunc1 = int4pl, basetype = int4, stype1 = int4,
   sfunc2 = int4inc, stype2 = int4,
   finalfunc = int4div,
   initcond1 = '0', initcond2 = '0'
);
QUERY: CREATE AGGREGATE newsum (
   sfunc1 = int4pl, basetype = int4, stype1 = int4,
   initcond1 = '0'
);
QUERY: CREATE AGGREGATE newcnt (
   sfunc2 = int4inc, basetype = int4, stype2 = int4,
   initcond2 = '0'
);