-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathSVDlib.sql
59 lines (48 loc) · 2.01 KB
/
SVDlib.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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
DROP FUNCTION IF EXISTS vector_of(int4, float8);
CREATE FUNCTION vector_of(int4, float8) RETURNS FLOAT8[]
AS 'SVDlib.so', 'vector_of'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_add_remove_null(float8[], float8[]);
CREATE FUNCTION array_add_remove_null(float8[], float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_add_remove_null'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_add(float8[], float8[]);
CREATE FUNCTION array_add(float8[], float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_add'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_sub(float8[], float8[]);
CREATE FUNCTION array_sub(float8[], float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_sub'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_mult(float8[], float8[]);
CREATE FUNCTION array_mult(float8[], float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_mult'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_div(float8[], float8[]);
CREATE FUNCTION array_div(float8[], float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_div'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_dif(float8[], float8[]);
CREATE FUNCTION array_dif(float8[], float8[]) RETURNS FLOAT8
AS 'SVDlib.so', 'array_dif'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_sum(float8[]);
CREATE FUNCTION array_sum(float8[]) RETURNS FLOAT8
AS 'SVDlib.so', 'array_sum'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_dot(float8[], float8[]);
CREATE FUNCTION array_dot(float8[], float8[]) RETURNS FLOAT8
AS 'SVDlib.so', 'array_dot'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_scalar_mult(float8[], float8);
CREATE FUNCTION array_scalar_mult(float8[], float8) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_scalar_mult'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_sqrt(float8[]);
CREATE FUNCTION array_sqrt(float8[]) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_sqrt'
LANGUAGE C IMMUTABLE;
DROP FUNCTION IF EXISTS array_limit(float8[], float8, float8);
CREATE FUNCTION array_limit(float8[], float8, float8) RETURNS FLOAT8[]
AS 'SVDlib.so', 'array_limit'
LANGUAGE C IMMUTABLE;