forked from citusdata/postgresql-hll
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhll--2.10--2.11.sql
40 lines (35 loc) · 1.14 KB
/
hll--2.10--2.11.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
DROP AGGREGATE hll_add_agg (hll_hashval);
DROP AGGREGATE hll_add_agg (hll_hashval, integer);
DROP AGGREGATE hll_add_agg (hll_hashval, integer, integer);
DROP AGGREGATE hll_add_agg (hll_hashval, integer, integer, bigint);
DROP AGGREGATE hll_add_agg (hll_hashval, integer, integer, bigint, integer);
CREATE AGGREGATE hll_add_agg (hll_hashval) (
SFUNC = hll_add_trans0,
STYPE = internal,
SSPACE = 131120,
FINALFUNC = hll_pack
);
CREATE AGGREGATE hll_add_agg (hll_hashval, integer) (
SFUNC = hll_add_trans1,
STYPE = internal,
SSPACE = 131120,
FINALFUNC = hll_pack
);
CREATE AGGREGATE hll_add_agg (hll_hashval, integer, integer) (
SFUNC = hll_add_trans2,
STYPE = internal,
SSPACE = 131120,
FINALFUNC = hll_pack
);
CREATE AGGREGATE hll_add_agg (hll_hashval, integer, integer, bigint) (
SFUNC = hll_add_trans3,
STYPE = internal,
SSPACE = 131120,
FINALFUNC = hll_pack
);
CREATE AGGREGATE hll_add_agg (hll_hashval, integer, integer, bigint, integer) (
SFUNC = hll_add_trans4,
STYPE = internal,
SSPACE = 131120,
FINALFUNC = hll_pack
);