File: alter_function.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (107 lines) | stat: -rw-r--r-- 4,827 bytes parent folder | download | duplicates (3)
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
-- Issue:2089
ALTER FUNCTION fn OWNER TO auser;
ALTER FUNCTION fn(int, arg2 text) OWNER TO auser;
ALTER FUNCTION fn OWNER TO auser;
ALTER FUNCTION fn OWNER TO CURRENT_ROLE;
ALTER FUNCTION fn OWNER TO CURRENT_USER;
ALTER FUNCTION fn OWNER TO SESSION_USER;
ALTER FUNCTION public.fn OWNER TO auser;
ALTER FUNCTION public.fn OWNER TO CURRENT_USER;
ALTER FUNCTION public.fn OWNER TO CURRENT_ROLE;
ALTER FUNCTION public.fn OWNER TO SESSION_USER;
ALTER FUNCTION fn CALLED ON NULL INPUT;
ALTER FUNCTION public.fn CALLED ON NULL INPUT;
ALTER FUNCTION fn CALLED ON NULL INPUT RESTRICT;
ALTER FUNCTION fn(arg1 int) CALLED ON NULL INPUT RESTRICT;
ALTER FUNCTION public.fn(arg1 int) CALLED ON NULL INPUT RESTRICT;
ALTER FUNCTION fn RETURNS NULL ON NULL INPUT;
ALTER FUNCTION fn(int, text) RETURNS NULL ON NULL INPUT;
ALTER FUNCTION fn RETURNS NULL ON NULL INPUT RESTRICT;
ALTER FUNCTION public.fn RETURNS NULL ON NULL INPUT RESTRICT;
ALTER FUNCTION fn(int, text) RETURNS NULL ON NULL INPUT RESTRICT;
ALTER FUNCTION fn STRICT;
ALTER FUNCTION fn(int) STRICT;
ALTER FUNCTION fn STRICT RESTRICT;
ALTER FUNCTION public.fn STRICT RESTRICT;
ALTER FUNCTION fn(arg1 int) STRICT RESTRICT;
ALTER FUNCTION fn IMMUTABLE;
ALTER FUNCTION fn IMMUTABLE RESTRICT;
ALTER FUNCTION public.fn IMMUTABLE RESTRICT;
ALTER FUNCTION fn STABLE;
ALTER FUNCTION public.fn STABLE;
ALTER FUNCTION fn STABLE RESTRICT;
ALTER FUNCTION fn VOLATILE;
ALTER FUNCTION fn VOLATILE RESTRICT;
ALTER FUNCTION fn(int, arg2 text) IMMUTABLE;
ALTER FUNCTION fn(int, arg2 text) IMMUTABLE RESTRICT;
ALTER FUNCTION public.fn(int, arg2 text) IMMUTABLE RESTRICT;
ALTER FUNCTION fn(int) STABLE;
ALTER FUNCTION fn(int) STABLE RESTRICT;
ALTER FUNCTION fn(arg int) VOLATILE;
ALTER FUNCTION fn(arg int) VOLATILE RESTRICT;
ALTER FUNCTION fn LEAKPROOF;
ALTER FUNCTION fn LEAKPROOF RESTRICT;
ALTER FUNCTION fn(int, arg2 text) LEAKPROOF;
ALTER FUNCTION fn(int, arg2 text) LEAKPROOF RESTRICT;
ALTER FUNCTION fn NOT LEAKPROOF;
ALTER FUNCTION fn NOT LEAKPROOF RESTRICT;
ALTER FUNCTION fn(arg int) NOT LEAKPROOF;
ALTER FUNCTION fn(arg int) NOT LEAKPROOF RESTRICT;
ALTER FUNCTION fn SECURITY INVOKER;
ALTER FUNCTION fn SECURITY INVOKER RESTRICT;
ALTER FUNCTION fn(int, text, boolean) SECURITY INVOKER;
ALTER FUNCTION fn(int, text, boolean) SECURITY INVOKER RESTRICT;
ALTER FUNCTION fn EXTERNAL SECURITY INVOKER;
ALTER FUNCTION fn EXTERNAL SECURITY INVOKER RESTRICT;
ALTER FUNCTION fn(int, text) EXTERNAL SECURITY INVOKER;
ALTER FUNCTION fn(int, text) EXTERNAL SECURITY INVOKER RESTRICT;
ALTER FUNCTION fn SECURITY DEFINER;
ALTER FUNCTION fn SECURITY DEFINER RESTRICT;
ALTER FUNCTION fn EXTERNAL SECURITY DEFINER;
ALTER FUNCTION fn EXTERNAL SECURITY DEFINER RESTRICT;
ALTER FUNCTION fn(arg1 int, arg2 text, boolean) EXTERNAL SECURITY DEFINER;
ALTER FUNCTION fn(arg1 int, arg2 text, boolean) EXTERNAL SECURITY DEFINER RESTRICT;
ALTER FUNCTION fn PARALLEL UNSAFE;
ALTER FUNCTION fn(arg int) PARALLEL UNSAFE;
ALTER FUNCTION fn PARALLEL UNSAFE RESTRICT;
ALTER FUNCTION fn(int) PARALLEL UNSAFE RESTRICT;
ALTER FUNCTION fn PARALLEL RESTRICTED;
ALTER FUNCTION fn PARALLEL RESTRICTED RESTRICT;
ALTER FUNCTION fn(int, text) PARALLEL RESTRICTED;
ALTER FUNCTION fn(text) PARALLEL RESTRICTED RESTRICT;
ALTER FUNCTION fn PARALLEL SAFE;
ALTER FUNCTION public.fn PARALLEL SAFE RESTRICT;
ALTER FUNCTION fn(text, arg2 int) PARALLEL SAFE;
ALTER FUNCTION fn(text, text) PARALLEL SAFE RESTRICT;
ALTER FUNCTION fn COST 10;
ALTER FUNCTION fn COST 10 RESTRICT;
ALTER FUNCTION fn(arg1 int, arg2 text) COST 10;
ALTER FUNCTION fn(arg1 int, arg2 text) COST 10 RESTRICT;
ALTER FUNCTION fn ROWS 10;
ALTER FUNCTION fn ROWS 10 RESTRICT;
ALTER FUNCTION fn(arg1 int, arg2 text, int, int) ROWS 10;
ALTER FUNCTION fn(arg1 int, arg2 text, int, int) ROWS 10 RESTRICT;
ALTER FUNCTION fn SUPPORT supportfn;
ALTER FUNCTION public.fn SUPPORT supportfn;
ALTER FUNCTION fn(int, int) SUPPORT supportfn;
ALTER FUNCTION fn(int, int) SUPPORT supportfn RESTRICT;
ALTER FUNCTION fn SET param1 TO 1;
ALTER FUNCTION fn SET param1 TO 'value';
ALTER FUNCTION fn SET param1 TO DEFAULT;
ALTER FUNCTION fn SET param1 TO 'value' RESTRICT;
ALTER FUNCTION fn(int, int) SET param1 TO DEFAULT;
ALTER FUNCTION fn(int, int) SET param1 TO DEFAULT RESTRICT;
ALTER FUNCTION fn SET param1 TO avalue;
ALTER FUNCTION fn SET param1 = 1;
ALTER FUNCTION fn SET param1 = 'value';
ALTER FUNCTION fn SET param1 = avalue;
ALTER FUNCTION fn SET param1 = DEFAULT;
ALTER FUNCTION fn(arg1 int, arg2 text) SET param1 = 'value';
ALTER FUNCTION fn(int) SET param1 = avalue;
ALTER FUNCTION fn(text, int) SET param1 = avalue;
ALTER FUNCTION fn(int, int) SUPPORT supportfn;
ALTER FUNCTION fn SET param1 FROM CURRENT;
ALTER FUNCTION fn(boolean) SET param1 FROM CURRENT;
ALTER FUNCTION public.fn(boolean, int) SET param1 FROM CURRENT;
ALTER FUNCTION fn RESET param1;
ALTER FUNCTION fn RESET ALL;