PostgreSQL Source Code  git master
pg_aggregate.h
Go to the documentation of this file.
1 /*-------------------------------------------------------------------------
2  *
3  * pg_aggregate.h
4  * definition of the system "aggregate" relation (pg_aggregate)
5  * along with the relation's initial contents.
6  *
7  *
8  * Portions Copyright (c) 1996-2017, PostgreSQL Global Development Group
9  * Portions Copyright (c) 1994, Regents of the University of California
10  *
11  * src/include/catalog/pg_aggregate.h
12  *
13  * NOTES
14  * the genbki.pl script reads this file and generates .bki
15  * information from the DATA() statements.
16  *
17  *-------------------------------------------------------------------------
18  */
19 #ifndef PG_AGGREGATE_H
20 #define PG_AGGREGATE_H
21 
22 #include "catalog/genbki.h"
23 
24 /* ----------------------------------------------------------------
25  * pg_aggregate definition.
26  *
27  * cpp turns this into typedef struct FormData_pg_aggregate
28  *
29  * aggfnoid pg_proc OID of the aggregate itself
30  * aggkind aggregate kind, see AGGKIND_ categories below
31  * aggnumdirectargs number of arguments that are "direct" arguments
32  * aggtransfn transition function
33  * aggfinalfn final function (0 if none)
34  * aggcombinefn combine function (0 if none)
35  * aggserialfn function to convert transtype to bytea (0 if none)
36  * aggdeserialfn function to convert bytea to transtype (0 if none)
37  * aggmtransfn forward function for moving-aggregate mode (0 if none)
38  * aggminvtransfn inverse function for moving-aggregate mode (0 if none)
39  * aggmfinalfn final function for moving-aggregate mode (0 if none)
40  * aggfinalextra true to pass extra dummy arguments to aggfinalfn
41  * aggmfinalextra true to pass extra dummy arguments to aggmfinalfn
42  * aggfinalmodify tells whether aggfinalfn modifies transition state
43  * aggmfinalmodify tells whether aggmfinalfn modifies transition state
44  * aggsortop associated sort operator (0 if none)
45  * aggtranstype type of aggregate's transition (state) data
46  * aggtransspace estimated size of state data (0 for default estimate)
47  * aggmtranstype type of moving-aggregate state data (0 if none)
48  * aggmtransspace estimated size of moving-agg state (0 for default est)
49  * agginitval initial value for transition state (can be NULL)
50  * aggminitval initial value for moving-agg state (can be NULL)
51  * ----------------------------------------------------------------
52  */
53 #define AggregateRelationId 2600
54 
55 CATALOG(pg_aggregate,2600) BKI_WITHOUT_OIDS
56 {
57  regproc aggfnoid;
58  char aggkind;
59  int16 aggnumdirectargs;
60  regproc aggtransfn;
61  regproc aggfinalfn;
62  regproc aggcombinefn;
63  regproc aggserialfn;
64  regproc aggdeserialfn;
65  regproc aggmtransfn;
66  regproc aggminvtransfn;
67  regproc aggmfinalfn;
68  bool aggfinalextra;
69  bool aggmfinalextra;
70  char aggfinalmodify;
71  char aggmfinalmodify;
72  Oid aggsortop;
73  Oid aggtranstype;
74  int32 aggtransspace;
75  Oid aggmtranstype;
76  int32 aggmtransspace;
77 
78 #ifdef CATALOG_VARLEN /* variable-length fields start here */
79  text agginitval;
80  text aggminitval;
81 #endif
83 
84 /* ----------------
85  * Form_pg_aggregate corresponds to a pointer to a tuple with
86  * the format of pg_aggregate relation.
87  * ----------------
88  */
90 
91 /* ----------------
92  * compiler constants for pg_aggregate
93  * ----------------
94  */
95 
96 #define Natts_pg_aggregate 22
97 #define Anum_pg_aggregate_aggfnoid 1
98 #define Anum_pg_aggregate_aggkind 2
99 #define Anum_pg_aggregate_aggnumdirectargs 3
100 #define Anum_pg_aggregate_aggtransfn 4
101 #define Anum_pg_aggregate_aggfinalfn 5
102 #define Anum_pg_aggregate_aggcombinefn 6
103 #define Anum_pg_aggregate_aggserialfn 7
104 #define Anum_pg_aggregate_aggdeserialfn 8
105 #define Anum_pg_aggregate_aggmtransfn 9
106 #define Anum_pg_aggregate_aggminvtransfn 10
107 #define Anum_pg_aggregate_aggmfinalfn 11
108 #define Anum_pg_aggregate_aggfinalextra 12
109 #define Anum_pg_aggregate_aggmfinalextra 13
110 #define Anum_pg_aggregate_aggfinalmodify 14
111 #define Anum_pg_aggregate_aggmfinalmodify 15
112 #define Anum_pg_aggregate_aggsortop 16
113 #define Anum_pg_aggregate_aggtranstype 17
114 #define Anum_pg_aggregate_aggtransspace 18
115 #define Anum_pg_aggregate_aggmtranstype 19
116 #define Anum_pg_aggregate_aggmtransspace 20
117 #define Anum_pg_aggregate_agginitval 21
118 #define Anum_pg_aggregate_aggminitval 22
119 
120 /*
121  * Symbolic values for aggkind column. We distinguish normal aggregates
122  * from ordered-set aggregates (which have two sets of arguments, namely
123  * direct and aggregated arguments) and from hypothetical-set aggregates
124  * (which are a subclass of ordered-set aggregates in which the last
125  * direct arguments have to match up in number and datatypes with the
126  * aggregated arguments).
127  */
128 #define AGGKIND_NORMAL 'n'
129 #define AGGKIND_ORDERED_SET 'o'
130 #define AGGKIND_HYPOTHETICAL 'h'
131 
132 /* Use this macro to test for "ordered-set agg including hypothetical case" */
133 #define AGGKIND_IS_ORDERED_SET(kind) ((kind) != AGGKIND_NORMAL)
134 
135 /*
136  * Symbolic values for aggfinalmodify and aggmfinalmodify columns.
137  * Preferably, finalfns do not modify the transition state value at all,
138  * but in some cases that would cost too much performance. We distinguish
139  * "pure read only" and "trashes it arbitrarily" cases, as well as the
140  * intermediate case where multiple finalfn calls are allowed but the
141  * transfn cannot be applied anymore after the first finalfn call.
142  */
143 #define AGGMODIFY_READ_ONLY 'r'
144 #define AGGMODIFY_SHARABLE 's'
145 #define AGGMODIFY_READ_WRITE 'w'
146 
147 
148 /* ----------------
149  * initial contents of pg_aggregate
150  * ---------------
151  */
152 
153 /* avg */
155 DATA(insert ( 2101 n 0 int4_avg_accum int8_avg int4_avg_combine - - int4_avg_accum int4_avg_accum_inv int8_avg f f r r 0 1016 0 1016 0 "{0,0}" "{0,0}" ));
156 DATA(insert ( 2102 n 0 int2_avg_accum int8_avg int4_avg_combine - - int2_avg_accum int2_avg_accum_inv int8_avg f f r r 0 1016 0 1016 0 "{0,0}" "{0,0}" ));
158 DATA(insert ( 2104 n 0 float4_accum float8_avg float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
159 DATA(insert ( 2105 n 0 float8_accum float8_avg float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
160 DATA(insert ( 2106 n 0 interval_accum interval_avg interval_combine - - interval_accum interval_accum_inv interval_avg f f r r 0 1187 0 1187 0 "{0 second,0 second}" "{0 second,0 second}" ));
161 
162 /* sum */
164 DATA(insert ( 2108 n 0 int4_sum - int8pl - - int4_avg_accum int4_avg_accum_inv int2int4_sum f f r r 0 20 0 1016 0 _null_ "{0,0}" ));
165 DATA(insert ( 2109 n 0 int2_sum - int8pl - - int2_avg_accum int2_avg_accum_inv int2int4_sum f f r r 0 20 0 1016 0 _null_ "{0,0}" ));
166 DATA(insert ( 2110 n 0 float4pl - float4pl - - - - - f f r r 0 700 0 0 0 _null_ _null_ ));
167 DATA(insert ( 2111 n 0 float8pl - float8pl - - - - - f f r r 0 701 0 0 0 _null_ _null_ ));
168 DATA(insert ( 2112 n 0 cash_pl - cash_pl - - cash_pl cash_mi - f f r r 0 790 0 790 0 _null_ _null_ ));
169 DATA(insert ( 2113 n 0 interval_pl - interval_pl - - interval_pl interval_mi - f f r r 0 1186 0 1186 0 _null_ _null_ ));
171 
172 /* max */
173 DATA(insert ( 2115 n 0 int8larger - int8larger - - - - - f f r r 413 20 0 0 0 _null_ _null_ ));
174 DATA(insert ( 2116 n 0 int4larger - int4larger - - - - - f f r r 521 23 0 0 0 _null_ _null_ ));
175 DATA(insert ( 2117 n 0 int2larger - int2larger - - - - - f f r r 520 21 0 0 0 _null_ _null_ ));
176 DATA(insert ( 2118 n 0 oidlarger - oidlarger - - - - - f f r r 610 26 0 0 0 _null_ _null_ ));
177 DATA(insert ( 2119 n 0 float4larger - float4larger - - - - - f f r r 623 700 0 0 0 _null_ _null_ ));
178 DATA(insert ( 2120 n 0 float8larger - float8larger - - - - - f f r r 674 701 0 0 0 _null_ _null_ ));
179 DATA(insert ( 2121 n 0 int4larger - int4larger - - - - - f f r r 563 702 0 0 0 _null_ _null_ ));
180 DATA(insert ( 2122 n 0 date_larger - date_larger - - - - - f f r r 1097 1082 0 0 0 _null_ _null_ ));
181 DATA(insert ( 2123 n 0 time_larger - time_larger - - - - - f f r r 1112 1083 0 0 0 _null_ _null_ ));
182 DATA(insert ( 2124 n 0 timetz_larger - timetz_larger - - - - - f f r r 1554 1266 0 0 0 _null_ _null_ ));
183 DATA(insert ( 2125 n 0 cashlarger - cashlarger - - - - - f f r r 903 790 0 0 0 _null_ _null_ ));
184 DATA(insert ( 2126 n 0 timestamp_larger - timestamp_larger - - - - - f f r r 2064 1114 0 0 0 _null_ _null_ ));
185 DATA(insert ( 2127 n 0 timestamptz_larger - timestamptz_larger - - - - - f f r r 1324 1184 0 0 0 _null_ _null_ ));
186 DATA(insert ( 2128 n 0 interval_larger - interval_larger - - - - - f f r r 1334 1186 0 0 0 _null_ _null_ ));
187 DATA(insert ( 2129 n 0 text_larger - text_larger - - - - - f f r r 666 25 0 0 0 _null_ _null_ ));
188 DATA(insert ( 2130 n 0 numeric_larger - numeric_larger - - - - - f f r r 1756 1700 0 0 0 _null_ _null_ ));
189 DATA(insert ( 2050 n 0 array_larger - array_larger - - - - - f f r r 1073 2277 0 0 0 _null_ _null_ ));
190 DATA(insert ( 2244 n 0 bpchar_larger - bpchar_larger - - - - - f f r r 1060 1042 0 0 0 _null_ _null_ ));
191 DATA(insert ( 2797 n 0 tidlarger - tidlarger - - - - - f f r r 2800 27 0 0 0 _null_ _null_ ));
192 DATA(insert ( 3526 n 0 enum_larger - enum_larger - - - - - f f r r 3519 3500 0 0 0 _null_ _null_ ));
193 DATA(insert ( 3564 n 0 network_larger - network_larger - - - - - f f r r 1205 869 0 0 0 _null_ _null_ ));
194 
195 /* min */
196 DATA(insert ( 2131 n 0 int8smaller - int8smaller - - - - - f f r r 412 20 0 0 0 _null_ _null_ ));
197 DATA(insert ( 2132 n 0 int4smaller - int4smaller - - - - - f f r r 97 23 0 0 0 _null_ _null_ ));
198 DATA(insert ( 2133 n 0 int2smaller - int2smaller - - - - - f f r r 95 21 0 0 0 _null_ _null_ ));
199 DATA(insert ( 2134 n 0 oidsmaller - oidsmaller - - - - - f f r r 609 26 0 0 0 _null_ _null_ ));
200 DATA(insert ( 2135 n 0 float4smaller - float4smaller - - - - - f f r r 622 700 0 0 0 _null_ _null_ ));
201 DATA(insert ( 2136 n 0 float8smaller - float8smaller - - - - - f f r r 672 701 0 0 0 _null_ _null_ ));
202 DATA(insert ( 2137 n 0 int4smaller - int4smaller - - - - - f f r r 562 702 0 0 0 _null_ _null_ ));
203 DATA(insert ( 2138 n 0 date_smaller - date_smaller - - - - - f f r r 1095 1082 0 0 0 _null_ _null_ ));
204 DATA(insert ( 2139 n 0 time_smaller - time_smaller - - - - - f f r r 1110 1083 0 0 0 _null_ _null_ ));
205 DATA(insert ( 2140 n 0 timetz_smaller - timetz_smaller - - - - - f f r r 1552 1266 0 0 0 _null_ _null_ ));
206 DATA(insert ( 2141 n 0 cashsmaller - cashsmaller - - - - - f f r r 902 790 0 0 0 _null_ _null_ ));
207 DATA(insert ( 2142 n 0 timestamp_smaller - timestamp_smaller - - - - - f f r r 2062 1114 0 0 0 _null_ _null_ ));
208 DATA(insert ( 2143 n 0 timestamptz_smaller - timestamptz_smaller - - - - - f f r r 1322 1184 0 0 0 _null_ _null_ ));
209 DATA(insert ( 2144 n 0 interval_smaller - interval_smaller - - - - - f f r r 1332 1186 0 0 0 _null_ _null_ ));
210 DATA(insert ( 2145 n 0 text_smaller - text_smaller - - - - - f f r r 664 25 0 0 0 _null_ _null_ ));
211 DATA(insert ( 2146 n 0 numeric_smaller - numeric_smaller - - - - - f f r r 1754 1700 0 0 0 _null_ _null_ ));
212 DATA(insert ( 2051 n 0 array_smaller - array_smaller - - - - - f f r r 1072 2277 0 0 0 _null_ _null_ ));
213 DATA(insert ( 2245 n 0 bpchar_smaller - bpchar_smaller - - - - - f f r r 1058 1042 0 0 0 _null_ _null_ ));
214 DATA(insert ( 2798 n 0 tidsmaller - tidsmaller - - - - - f f r r 2799 27 0 0 0 _null_ _null_ ));
215 DATA(insert ( 3527 n 0 enum_smaller - enum_smaller - - - - - f f r r 3518 3500 0 0 0 _null_ _null_ ));
216 DATA(insert ( 3565 n 0 network_smaller - network_smaller - - - - - f f r r 1203 869 0 0 0 _null_ _null_ ));
217 
218 /* count */
219 DATA(insert ( 2147 n 0 int8inc_any - int8pl - - int8inc_any int8dec_any - f f r r 0 20 0 20 0 "0" "0" ));
220 DATA(insert ( 2803 n 0 int8inc - int8pl - - int8inc int8dec - f f r r 0 20 0 20 0 "0" "0" ));
221 
222 /* var_pop */
226 DATA(insert ( 2721 n 0 float4_accum float8_var_pop float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
227 DATA(insert ( 2722 n 0 float8_accum float8_var_pop float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
229 
230 /* var_samp */
234 DATA(insert ( 2644 n 0 float4_accum float8_var_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
235 DATA(insert ( 2645 n 0 float8_accum float8_var_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
237 
238 /* variance: historical Postgres syntax for var_samp */
242 DATA(insert ( 2151 n 0 float4_accum float8_var_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
243 DATA(insert ( 2152 n 0 float8_accum float8_var_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
245 
246 /* stddev_pop */
250 DATA(insert ( 2727 n 0 float4_accum float8_stddev_pop float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
251 DATA(insert ( 2728 n 0 float8_accum float8_stddev_pop float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
253 
254 /* stddev_samp */
258 DATA(insert ( 2715 n 0 float4_accum float8_stddev_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
259 DATA(insert ( 2716 n 0 float8_accum float8_stddev_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
261 
262 /* stddev: historical Postgres syntax for stddev_samp */
266 DATA(insert ( 2157 n 0 float4_accum float8_stddev_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
267 DATA(insert ( 2158 n 0 float8_accum float8_stddev_samp float8_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0}" _null_ ));
269 
270 /* SQL2003 binary regression aggregates */
271 DATA(insert ( 2818 n 0 int8inc_float8_float8 - int8pl - - - - - f f r r 0 20 0 0 0 "0" _null_ ));
272 DATA(insert ( 2819 n 0 float8_regr_accum float8_regr_sxx float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
273 DATA(insert ( 2820 n 0 float8_regr_accum float8_regr_syy float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
274 DATA(insert ( 2821 n 0 float8_regr_accum float8_regr_sxy float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
275 DATA(insert ( 2822 n 0 float8_regr_accum float8_regr_avgx float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
276 DATA(insert ( 2823 n 0 float8_regr_accum float8_regr_avgy float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
277 DATA(insert ( 2824 n 0 float8_regr_accum float8_regr_r2 float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
278 DATA(insert ( 2825 n 0 float8_regr_accum float8_regr_slope float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
279 DATA(insert ( 2826 n 0 float8_regr_accum float8_regr_intercept float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
280 DATA(insert ( 2827 n 0 float8_regr_accum float8_covar_pop float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
281 DATA(insert ( 2828 n 0 float8_regr_accum float8_covar_samp float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
282 DATA(insert ( 2829 n 0 float8_regr_accum float8_corr float8_regr_combine - - - - - f f r r 0 1022 0 0 0 "{0,0,0,0,0,0}" _null_ ));
283 
284 /* boolean-and and boolean-or */
285 DATA(insert ( 2517 n 0 booland_statefunc - booland_statefunc - - bool_accum bool_accum_inv bool_alltrue f f r r 58 16 0 2281 16 _null_ _null_ ));
286 DATA(insert ( 2518 n 0 boolor_statefunc - boolor_statefunc - - bool_accum bool_accum_inv bool_anytrue f f r r 59 16 0 2281 16 _null_ _null_ ));
287 DATA(insert ( 2519 n 0 booland_statefunc - booland_statefunc - - bool_accum bool_accum_inv bool_alltrue f f r r 58 16 0 2281 16 _null_ _null_ ));
288 
289 /* bitwise integer */
290 DATA(insert ( 2236 n 0 int2and - int2and - - - - - f f r r 0 21 0 0 0 _null_ _null_ ));
291 DATA(insert ( 2237 n 0 int2or - int2or - - - - - f f r r 0 21 0 0 0 _null_ _null_ ));
292 DATA(insert ( 2238 n 0 int4and - int4and - - - - - f f r r 0 23 0 0 0 _null_ _null_ ));
293 DATA(insert ( 2239 n 0 int4or - int4or - - - - - f f r r 0 23 0 0 0 _null_ _null_ ));
294 DATA(insert ( 2240 n 0 int8and - int8and - - - - - f f r r 0 20 0 0 0 _null_ _null_ ));
295 DATA(insert ( 2241 n 0 int8or - int8or - - - - - f f r r 0 20 0 0 0 _null_ _null_ ));
296 DATA(insert ( 2242 n 0 bitand - bitand - - - - - f f r r 0 1560 0 0 0 _null_ _null_ ));
297 DATA(insert ( 2243 n 0 bitor - bitor - - - - - f f r r 0 1560 0 0 0 _null_ _null_ ));
298 
299 /* xml */
300 DATA(insert ( 2901 n 0 xmlconcat2 - - - - - - - f f r r 0 142 0 0 0 _null_ _null_ ));
301 
302 /* array */
303 DATA(insert ( 2335 n 0 array_agg_transfn array_agg_finalfn - - - - - - t f r r 0 2281 0 0 0 _null_ _null_ ));
304 DATA(insert ( 4053 n 0 array_agg_array_transfn array_agg_array_finalfn - - - - - - t f r r 0 2281 0 0 0 _null_ _null_ ));
305 
306 /* text */
307 DATA(insert ( 3538 n 0 string_agg_transfn string_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
308 
309 /* bytea */
310 DATA(insert ( 3545 n 0 bytea_string_agg_transfn bytea_string_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
311 
312 /* json */
313 DATA(insert ( 3175 n 0 json_agg_transfn json_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
314 DATA(insert ( 3197 n 0 json_object_agg_transfn json_object_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
315 
316 /* jsonb */
317 DATA(insert ( 3267 n 0 jsonb_agg_transfn jsonb_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
318 DATA(insert ( 3270 n 0 jsonb_object_agg_transfn jsonb_object_agg_finalfn - - - - - - f f r r 0 2281 0 0 0 _null_ _null_ ));
319 
320 /* ordered-set and hypothetical-set aggregates */
321 DATA(insert ( 3972 o 1 ordered_set_transition percentile_disc_final - - - - - - t f s s 0 2281 0 0 0 _null_ _null_ ));
322 DATA(insert ( 3974 o 1 ordered_set_transition percentile_cont_float8_final - - - - - - f f s s 0 2281 0 0 0 _null_ _null_ ));
323 DATA(insert ( 3976 o 1 ordered_set_transition percentile_cont_interval_final - - - - - - f f s s 0 2281 0 0 0 _null_ _null_ ));
324 DATA(insert ( 3978 o 1 ordered_set_transition percentile_disc_multi_final - - - - - - t f s s 0 2281 0 0 0 _null_ _null_ ));
325 DATA(insert ( 3980 o 1 ordered_set_transition percentile_cont_float8_multi_final - - - - - - f f s s 0 2281 0 0 0 _null_ _null_ ));
326 DATA(insert ( 3982 o 1 ordered_set_transition percentile_cont_interval_multi_final - - - - - - f f s s 0 2281 0 0 0 _null_ _null_ ));
327 DATA(insert ( 3984 o 0 ordered_set_transition mode_final - - - - - - t f s s 0 2281 0 0 0 _null_ _null_ ));
328 DATA(insert ( 3986 h 1 ordered_set_transition_multi rank_final - - - - - - t f w w 0 2281 0 0 0 _null_ _null_ ));
329 DATA(insert ( 3988 h 1 ordered_set_transition_multi percent_rank_final - - - - - - t f w w 0 2281 0 0 0 _null_ _null_ ));
330 DATA(insert ( 3990 h 1 ordered_set_transition_multi cume_dist_final - - - - - - t f w w 0 2281 0 0 0 _null_ _null_ ));
331 DATA(insert ( 3992 h 1 ordered_set_transition_multi dense_rank_final - - - - - - t f w w 0 2281 0 0 0 _null_ _null_ ));
332 
333 #endif /* PG_AGGREGATE_H */
Datum interval_smaller(PG_FUNCTION_ARGS)
Definition: timestamp.c:3030
Datum int8_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:4073
signed short int16
Definition: c.h:283
Datum float4pl(PG_FUNCTION_ARGS)
Definition: float.c:801
Datum int4_avg_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:5302
Datum interval_larger(PG_FUNCTION_ARGS)
Definition: timestamp.c:3045
Datum float8_stddev_pop(PG_FUNCTION_ARGS)
Definition: float.c:2712
Datum numeric_avg_combine(PG_FUNCTION_ARGS)
Definition: numeric.c:3590
Datum float8larger(PG_FUNCTION_ARGS)
Definition: float.c:760
Datum numeric_deserialize(PG_FUNCTION_ARGS)
Definition: numeric.c:3837
Datum int8_avg_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:4299
Datum float8_regr_syy(PG_FUNCTION_ARGS)
Definition: float.c:2949
Datum int4_avg_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:5215
Datum numeric_poly_stddev_pop(PG_FUNCTION_ARGS)
Definition: numeric.c:4994
Datum numeric_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:3482
Datum numeric_poly_sum(PG_FUNCTION_ARGS)
Definition: numeric.c:4612
Datum float4larger(PG_FUNCTION_ARGS)
Definition: float.c:693
Datum float8_regr_sxy(PG_FUNCTION_ARGS)
Definition: float.c:2978
Datum oidsmaller(PG_FUNCTION_ARGS)
Definition: oid.c:417
Datum percentile_cont_float8_final(PG_FUNCTION_ARGS)
Datum float8_var_samp(PG_FUNCTION_ARGS)
Definition: float.c:2683
CATALOG(pg_aggregate, 2600) BKI_WITHOUT_OIDS
Definition: pg_aggregate.h:55
Datum percentile_cont_interval_final(PG_FUNCTION_ARGS)
Datum array_agg_finalfn(PG_FUNCTION_ARGS)
Datum tidsmaller(PG_FUNCTION_ARGS)
Definition: tid.c:234
Datum percentile_disc_final(PG_FUNCTION_ARGS)
Datum array_agg_transfn(PG_FUNCTION_ARGS)
Datum bool_anytrue(PG_FUNCTION_ARGS)
Definition: bool.c:392
Datum int4and(PG_FUNCTION_ARGS)
Definition: int.c:1211
Datum int8pl(PG_FUNCTION_ARGS)
Definition: int8.c:513
Datum int8_avg_deserialize(PG_FUNCTION_ARGS)
Definition: numeric.c:4447
Datum bpchar_smaller(PG_FUNCTION_ARGS)
Definition: varchar.c:905
Datum int2and(PG_FUNCTION_ARGS)
Definition: int.c:1264
Datum float8_covar_pop(PG_FUNCTION_ARGS)
Definition: float.c:3046
Datum numeric_avg_serialize(PG_FUNCTION_ARGS)
Definition: numeric.c:3658
Datum numeric_var_samp(PG_FUNCTION_ARGS)
Definition: numeric.c:4817
Datum json_agg_finalfn(PG_FUNCTION_ARGS)
Definition: json.c:1954
Datum float8_regr_r2(PG_FUNCTION_ARGS)
Definition: float.c:3142
Datum bytea_string_agg_finalfn(PG_FUNCTION_ARGS)
Definition: varlena.c:482
Datum string_agg_transfn(PG_FUNCTION_ARGS)
Definition: varlena.c:4699
Datum float8_regr_sxx(PG_FUNCTION_ARGS)
Definition: float.c:2920
Datum numeric_var_pop(PG_FUNCTION_ARGS)
Definition: numeric.c:4851
unsigned int Oid
Definition: postgres_ext.h:31
Datum float8_avg(PG_FUNCTION_ARGS)
Definition: float.c:2634
Datum interval_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:3093
Datum ordered_set_transition(PG_FUNCTION_ARGS)
signed int int32
Definition: c.h:284
Datum float4_accum(PG_FUNCTION_ARGS)
Definition: float.c:2581
Datum int8larger(PG_FUNCTION_ARGS)
Definition: int8.c:794
#define BKI_WITHOUT_OIDS
Definition: genbki.h:28
Datum int8smaller(PG_FUNCTION_ARGS)
Definition: int8.c:806
Datum oidlarger(PG_FUNCTION_ARGS)
Definition: oid.c:408
Datum int4_sum(PG_FUNCTION_ARGS)
Definition: numeric.c:5084
Datum int8inc_float8_float8(PG_FUNCTION_ARGS)
Definition: int8.c:781
Datum time_larger(PG_FUNCTION_ARGS)
Definition: date.c:1518
Datum interval_pl(PG_FUNCTION_ARGS)
Definition: timestamp.c:3059
Datum float8_regr_slope(PG_FUNCTION_ARGS)
Definition: float.c:3186
Datum numeric_combine(PG_FUNCTION_ARGS)
Definition: numeric.c:3502
Datum string_agg_finalfn(PG_FUNCTION_ARGS)
Definition: varlena.c:4725
Datum float8pl(PG_FUNCTION_ARGS)
Definition: float.c:870
Datum jsonb_object_agg_finalfn(PG_FUNCTION_ARGS)
Definition: jsonb.c:1869
Datum cashsmaller(PG_FUNCTION_ARGS)
Definition: cash.c:930
Datum jsonb_object_agg_transfn(PG_FUNCTION_ARGS)
Definition: jsonb.c:1673
Datum int8and(PG_FUNCTION_ARGS)
Definition: int8.c:1222
Datum timestamp_smaller(PG_FUNCTION_ARGS)
Definition: timestamp.c:2573
Datum int8_avg_combine(PG_FUNCTION_ARGS)
Definition: numeric.c:4330
Datum int2smaller(PG_FUNCTION_ARGS)
Definition: int.c:1173
Datum int4larger(PG_FUNCTION_ARGS)
Definition: int.c:1182
Datum bpchar_larger(PG_FUNCTION_ARGS)
Definition: varchar.c:887
Datum date_larger(PG_FUNCTION_ARGS)
Definition: date.c:486
Datum text_larger(PG_FUNCTION_ARGS)
Definition: varlena.c:2591
Datum numeric_stddev_pop(PG_FUNCTION_ARGS)
Definition: numeric.c:4868
Datum text_smaller(PG_FUNCTION_ARGS)
Definition: varlena.c:2603
Datum int2_avg_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:5187
Datum timestamp_larger(PG_FUNCTION_ARGS)
Definition: timestamp.c:2588
Datum int8_avg_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:4582
Datum float8_regr_combine(PG_FUNCTION_ARGS)
Definition: float.c:2865
FormData_pg_aggregate
Definition: pg_aggregate.h:82
Datum int8inc(PG_FUNCTION_ARGS)
Definition: int8.c:677
Datum network_smaller(PG_FUNCTION_ARGS)
Definition: network.c:453
Datum interval_accum_inv(PG_FUNCTION_ARGS)
Definition: timestamp.c:3356
Datum int2_avg_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:5274
Datum int8_avg(PG_FUNCTION_ARGS)
Definition: numeric.c:5330
Datum array_agg_array_transfn(PG_FUNCTION_ARGS)
Datum cash_pl(PG_FUNCTION_ARGS)
Definition: cash.c:612
Datum mode_final(PG_FUNCTION_ARGS)
Datum numeric_larger(PG_FUNCTION_ARGS)
Definition: numeric.c:2614
Datum percentile_cont_interval_multi_final(PG_FUNCTION_ARGS)
Datum float8_covar_samp(PG_FUNCTION_ARGS)
Definition: float.c:3074
Datum numeric_avg(PG_FUNCTION_ARGS)
Definition: numeric.c:4671
Datum enum_larger(PG_FUNCTION_ARGS)
Definition: enum.c:285
Datum float8_regr_intercept(PG_FUNCTION_ARGS)
Definition: float.c:3221
Datum percentile_disc_multi_final(PG_FUNCTION_ARGS)
Datum int8_avg_serialize(PG_FUNCTION_ARGS)
Definition: numeric.c:4390
Datum numeric_poly_stddev_samp(PG_FUNCTION_ARGS)
Definition: numeric.c:4952
Datum numeric_serialize(PG_FUNCTION_ARGS)
Definition: numeric.c:3770
Datum json_object_agg_finalfn(PG_FUNCTION_ARGS)
Definition: json.c:2070
Datum int8dec(PG_FUNCTION_ARGS)
Definition: int8.c:721
Datum numeric_smaller(PG_FUNCTION_ARGS)
Definition: numeric.c:2592
Datum bool_accum(PG_FUNCTION_ARGS)
Definition: bool.c:335
Datum cash_mi(PG_FUNCTION_ARGS)
Definition: cash.c:628
Datum tidlarger(PG_FUNCTION_ARGS)
Definition: tid.c:225
Datum float8_regr_avgx(PG_FUNCTION_ARGS)
Definition: float.c:3008
Datum numeric_stddev_samp(PG_FUNCTION_ARGS)
Definition: numeric.c:4834
Datum int4_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:4046
Datum int8dec_any(PG_FUNCTION_ARGS)
Definition: int8.c:787
Datum enum_smaller(PG_FUNCTION_ARGS)
Definition: enum.c:276
Datum float8_accum(PG_FUNCTION_ARGS)
Definition: float.c:2530
Datum int4or(PG_FUNCTION_ARGS)
Definition: int.c:1220
Datum float4smaller(PG_FUNCTION_ARGS)
Definition: float.c:707
Datum date_smaller(PG_FUNCTION_ARGS)
Definition: date.c:495
Datum interval_avg(PG_FUNCTION_ARGS)
Definition: timestamp.c:3391
Datum numeric_poly_deserialize(PG_FUNCTION_ARGS)
Definition: numeric.c:4235
Datum int2_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:4019
Datum float8_var_pop(PG_FUNCTION_ARGS)
Definition: float.c:2654
Datum int4_avg_combine(PG_FUNCTION_ARGS)
Definition: numeric.c:5243
Datum jsonb_agg_transfn(PG_FUNCTION_ARGS)
Definition: jsonb.c:1520
Datum int2larger(PG_FUNCTION_ARGS)
Definition: int.c:1164
Datum float8_regr_accum(PG_FUNCTION_ARGS)
Definition: float.c:2786
Datum json_object_agg_transfn(PG_FUNCTION_ARGS)
Definition: json.c:1979
Datum int2_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:4496
Datum xmlconcat2(PG_FUNCTION_ARGS)
Definition: xml.c:576
Datum timetz_smaller(PG_FUNCTION_ARGS)
Definition: date.c:2253
Datum boolor_statefunc(PG_FUNCTION_ARGS)
Definition: bool.c:306
Datum int4_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:4526
FormData_pg_aggregate * Form_pg_aggregate
Definition: pg_aggregate.h:89
Datum cashlarger(PG_FUNCTION_ARGS)
Definition: cash.c:915
Datum float8smaller(PG_FUNCTION_ARGS)
Definition: float.c:774
Datum int2or(PG_FUNCTION_ARGS)
Definition: int.c:1273
Datum int2int4_sum(PG_FUNCTION_ARGS)
Definition: numeric.c:5359
Datum int8_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:4556
Datum int2_sum(PG_FUNCTION_ARGS)
Definition: numeric.c:5035
Datum array_larger(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:5571
Datum time_smaller(PG_FUNCTION_ARGS)
Definition: date.c:1527
Datum interval_combine(PG_FUNCTION_ARGS)
Definition: timestamp.c:3307
Datum json_agg_transfn(PG_FUNCTION_ARGS)
Definition: json.c:1878
Datum float8_corr(PG_FUNCTION_ARGS)
Definition: float.c:3102
Oid regproc
Definition: c.h:442
DATA(insert(2100 n 0 int8_avg_accum numeric_poly_avg int8_avg_combine int8_avg_serialize int8_avg_deserialize int8_avg_accum int8_avg_accum_inv numeric_poly_avg f f r r 0 2281 48 2281 48 _null_ _null_))
Datum bool_accum_inv(PG_FUNCTION_ARGS)
Definition: bool.c:356
Datum float8_combine(PG_FUNCTION_ARGS)
Definition: float.c:2494
Datum array_smaller(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:5580
Datum numeric_avg_accum(PG_FUNCTION_ARGS)
Definition: numeric.c:3570
Datum int8or(PG_FUNCTION_ARGS)
Definition: int8.c:1231
Datum bytea_string_agg_transfn(PG_FUNCTION_ARGS)
Definition: varlena.c:450
Datum numeric_poly_avg(PG_FUNCTION_ARGS)
Definition: numeric.c:4640
Datum float8_stddev_samp(PG_FUNCTION_ARGS)
Definition: float.c:2741
Datum network_larger(PG_FUNCTION_ARGS)
Definition: network.c:465
Datum numeric_poly_var_samp(PG_FUNCTION_ARGS)
Definition: numeric.c:4931
Definition: c.h:487
Datum int8inc_any(PG_FUNCTION_ARGS)
Definition: int8.c:775
Datum ordered_set_transition_multi(PG_FUNCTION_ARGS)
Datum numeric_avg_deserialize(PG_FUNCTION_ARGS)
Definition: numeric.c:3715
Datum numeric_poly_combine(PG_FUNCTION_ARGS)
Definition: numeric.c:4099
Datum interval_accum(PG_FUNCTION_ARGS)
Definition: timestamp.c:3272
Datum jsonb_agg_finalfn(PG_FUNCTION_ARGS)
Definition: jsonb.c:1638
Datum array_agg_array_finalfn(PG_FUNCTION_ARGS)
Datum int4smaller(PG_FUNCTION_ARGS)
Definition: int.c:1191
Datum numeric_accum_inv(PG_FUNCTION_ARGS)
Definition: numeric.c:3900
Datum numeric_sum(PG_FUNCTION_ARGS)
Definition: numeric.c:4698
Datum numeric_poly_var_pop(PG_FUNCTION_ARGS)
Definition: numeric.c:4973
Datum percentile_cont_float8_multi_final(PG_FUNCTION_ARGS)
Datum float8_regr_avgy(PG_FUNCTION_ARGS)
Definition: float.c:3027
Datum numeric_poly_serialize(PG_FUNCTION_ARGS)
Definition: numeric.c:4164
Datum timetz_larger(PG_FUNCTION_ARGS)
Definition: date.c:2239
Datum bool_alltrue(PG_FUNCTION_ARGS)
Definition: bool.c:377
Datum booland_statefunc(PG_FUNCTION_ARGS)
Definition: bool.c:294