forked from ChenHuajun/pg_roaringbitmap
-
Notifications
You must be signed in to change notification settings - Fork 0
/
roaringbitmap--0.4--0.5.sql
37 lines (32 loc) · 1.03 KB
/
roaringbitmap--0.4--0.5.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
/* roaringbitmap--0.4--0.5 */
-- Redefine rb_or_cardinality_agg/rb_and_cardinality_agg/rb_xor_cardinality_agg to support parallel aggregate
DROP AGGREGATE rb_or_cardinality_agg(roaringbitmap);
CREATE AGGREGATE rb_or_cardinality_agg(roaringbitmap)(
SFUNC = rb_or_trans,
STYPE = internal,
FINALFUNC = rb_cardinality_final,
COMBINEFUNC = rb_or_combine,
SERIALFUNC = rb_serialize,
DESERIALFUNC = rb_deserialize,
PARALLEL = SAFE
);
DROP AGGREGATE rb_and_cardinality_agg(roaringbitmap);
CREATE AGGREGATE rb_and_cardinality_agg(roaringbitmap)(
SFUNC = rb_and_trans,
STYPE = internal,
FINALFUNC = rb_cardinality_final,
COMBINEFUNC = rb_and_combine,
SERIALFUNC = rb_serialize,
DESERIALFUNC = rb_deserialize,
PARALLEL = SAFE
);
DROP AGGREGATE rb_xor_cardinality_agg(roaringbitmap);
CREATE AGGREGATE rb_xor_cardinality_agg(roaringbitmap)(
SFUNC = rb_xor_trans,
STYPE = internal,
FINALFUNC = rb_cardinality_final,
COMBINEFUNC = rb_xor_combine,
SERIALFUNC = rb_serialize,
DESERIALFUNC = rb_deserialize,
PARALLEL = SAFE
);