-
Notifications
You must be signed in to change notification settings - Fork 9
/
fixeddecimalaggstate.sql
41 lines (33 loc) · 1.12 KB
/
fixeddecimalaggstate.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
--------------------------
-- FIXEDDECIMALAGGSTATE --
-------------------------
CREATE TYPE FIXEDDECIMALAGGSTATE;
CREATE FUNCTION fixeddecimalaggstatein(cstring, oid, int4)
RETURNS FIXEDDECIMALAGGSTATE
AS 'fixeddecimal', 'fixeddecimalaggstatein'
LANGUAGE C IMMUTABLE STRICT;
CREATE FUNCTION fixeddecimalaggstateout(fixeddecimalaggstate)
RETURNS cstring
AS 'fixeddecimal', 'fixeddecimalaggstateout'
LANGUAGE C IMMUTABLE STRICT;
CREATE FUNCTION fixeddecimalaggstaterecv(internal)
RETURNS FIXEDDECIMALAGGSTATE
AS 'fixeddecimal', 'fixeddecimalaggstaterecv'
LANGUAGE C IMMUTABLE STRICT;
CREATE FUNCTION fixeddecimalaggstatesend(FIXEDDECIMALAGGSTATE)
RETURNS bytea
AS 'fixeddecimal', 'fixeddecimalaggstatesend'
LANGUAGE C IMMUTABLE STRICT;
CREATE TYPE FIXEDDECIMALAGGSTATE (
INPUT = fixeddecimalaggstatein,
OUTPUT = fixeddecimalaggstateout,
RECEIVE = fixeddecimalaggstaterecv,
SEND = fixeddecimalaggstatesend,
INTERNALLENGTH = 8,
ALIGNMENT = 'double',
STORAGE = plain,
CATEGORY = 'N',
PREFERRED = false,
COLLATABLE = false,
PASSEDBYVALUE
);