forked from bashtanov/argm
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathargm--1.0.2.sql
More file actions
38 lines (36 loc) · 1.27 KB
/
argm--1.0.2.sql
File metadata and controls
38 lines (36 loc) · 1.27 KB
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
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION argm" to load this file. \quit
create function argmax_transfn(internal, anyelement, variadic "any") returns internal as
'MODULE_PATHNAME', 'argmax_transfn' language c;
create function argmin_transfn(internal, anyelement, variadic "any") returns internal as
'MODULE_PATHNAME', 'argmin_transfn' language c;
create function argm_finalfn(internal, anyelement, variadic "any") returns anyelement as
'MODULE_PATHNAME', 'argm_finalfn' language c;
create function anyold_transfn(internal, anyelement) returns internal as
'MODULE_PATHNAME', 'anyold_transfn' language c;
create function anyold_finalfn(internal, anyelement) returns anyelement as
'MODULE_PATHNAME', 'anyold_transfn' language c;
create aggregate argmax(anyelement, variadic "any")
(
sfunc = argmax_transfn,
stype = internal,
sspace = 128,
finalfunc = argm_finalfn,
finalfunc_extra
);
create aggregate argmin(anyelement, variadic "any")
(
sfunc = argmin_transfn,
stype = internal,
sspace = 128,
finalfunc = argm_finalfn,
finalfunc_extra
);
create aggregate anyold(anyelement)
(
sfunc = anyold_transfn,
stype = internal,
sspace = 8,
finalfunc = anyold_finalfn,
finalfunc_extra
);