--==========BAF5C2B261E75ECA6438==========
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Please find attached a patch that adds some missing descriptions for
aggregates, functions and conversions. This will add COMMENTs to the
conversion sql script as well. Most of the descriptions are taken from the
do***entation (especially for the statistic functions). I didn't bother
with some internal functions like text_pattern_lt, if we agree they should
be described as well i can add them, too.
--
Thanks
Bernd
--==========BAF5C2B261E75ECA6438==========
Content-Type: text/x-diff; charset=utf-8; name="function_descr.patch"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="function_descr.patch";
size=25419
? function_descr.patch
Index: src/backend/utils/mb/conversion_procs/Makefile
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file:
/projects/cvsroot/pgsql/src/backend/utils/mb/conversion_procs/Mak=
efile,v
retrieving revision 1.19
diff -c -b -r1.19 Makefile
*** src/backend/utils/mb/conversion_procs/Makefile 18 Mar 2008 16:24:50
-00=
00 1.19
--- src/backend/utils/mb/conversion_procs/Makefile 8 Jul 2008 15:06:47
-0000
***************
*** 175,182 ****
--- 175,184 ----
obj=3D$$1; ****ft; \
echo "-- $$se --> $$de"; \
echo "CREATE OR REPLACE FUNCTION $$func (INTEGER, INTEGER, CSTRING,
INT=
ERNAL, INTEGER) RETURNS VOID AS '$$"libdir"/$$obj', '$$func' LANGUAGE C
STR=
ICT;"; \
+ echo "COMMENT ON FUNCTION $$func(INTEGER, INTEGER, CSTRING,
INTE=
RNAL, INTEGER) IS 'internal conversion function for $$se to $$de';"; \
echo "DROP CONVERSION pg_catalog.$$name;"; \
echo "CREATE DEFAULT CONVERSION pg_catalog.$$name FOR '$$se' TO '$$de'
=
FROM $$func;"; \
+ echo "COMMENT ON CONVERSION pg_catalog.$$name IS 'conversion
for=
$$se to $$de';"; \
done > $@[EMAIL PROTECTED]
else
echo "-- No conversion sup****t, for lack of shared library sup****t" >
$@[EMAIL PROTECTED]
src/include/catalog/pg_proc.h
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /projects/cvsroot/pgsql/src/include/catalog/pg_proc.h,v
retrieving revision 1.504
diff -c -b -r1.504 pg_proc.h
*** src/include/catalog/pg_proc.h 3 Jul 2008 20:58:46 -0000 1.504
--- src/include/catalog/pg_proc.h 8 Jul 2008 15:06:47 -0000
***************
*** 235,241 ****
DATA(insert OID =3D 110 ( unknownout PGNSP PGUID 12 1 0 f f t f i 1
=
2275 "705" _null_ _null_ _null_ unknownout - _null_ _null_ ));
DESCR("I/O");
DATA(insert OID =3D 111 ( numeric_fac PGNSP PGUID 12 1 0 f f t f i 1
=
1700 "20" _null_ _null_ _null_ numeric_fac - _null_ _null_ ));
!=20
DATA(insert OID =3D 115 ( box_above_eq PGNSP PGUID 12 1 0 f f t f i
2=
16 "603 603" _null_ _null_ _null_ box_above_eq - _null_ _null_ ));
DESCR("is above (allows touching)");
DATA(insert OID =3D 116 ( box_below_eq PGNSP PGUID 12 1 0 f f t f i
2=
16 "603 603" _null_ _null_ _null_ box_below_eq - _null_ _null_ ));
--- 235,241 ----
DATA(insert OID =3D 110 ( unknownout PGNSP PGUID 12 1 0 f f t f i 1
=
2275 "705" _null_ _null_ _null_ unknownout - _null_ _null_ ));
DESCR("I/O");
DATA(insert OID =3D 111 ( numeric_fac PGNSP PGUID 12 1 0 f f t f i 1
=
1700 "20" _null_ _null_ _null_ numeric_fac - _null_ _null_ ));
! DESCR("equivalent to factorial");
DATA(insert OID =3D 115 ( box_above_eq PGNSP PGUID 12 1 0 f f t f i
2=
16 "603 603" _null_ _null_ _null_ box_above_eq - _null_ _null_ ));
DESCR("is above (allows touching)");
DATA(insert OID =3D 116 ( box_below_eq PGNSP PGUID 12 1 0 f f t f i
2=
16 "603 603" _null_ _null_ _null_ box_below_eq - _null_ _null_ ));
***************
*** 3220,3340 ****
--- 3220,3444 ----
/* Aggregates (moved here from pg_aggregate for 7.3) */
=20=20
DATA(insert OID =3D 2100 ( avg PGNSP PGUID 12 1 0 t f f f i 1 1700
"2=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as numeric of all bigint values");
DATA(insert OID =3D 2101 ( avg PGNSP PGUID 12 1 0 t f f f i 1 1700
"2=
3" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as numeric of all integer values");
DATA(insert OID =3D 2102 ( avg PGNSP PGUID 12 1 0 t f f f i 1 1700
"2=
1" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as numeric of all smallint
values");
DATA(insert OID =3D 2103 ( avg PGNSP PGUID 12 1 0 t f f f i 1 1700
"1=
700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as numeric of all numeric values");
DATA(insert OID =3D 2104 ( avg PGNSP PGUID 12 1 0 t f f f i 1 701
"70=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as float8 of all float4 values");
DATA(insert OID =3D 2105 ( avg PGNSP PGUID 12 1 0 t f f f i 1 701
"70=
1" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as float8 of all float8 values");
DATA(insert OID =3D 2106 ( avg PGNSP PGUID 12 1 0 t f f f i 1 1186
"1=
186" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("the average (arithmetic mean) as interval of all interval
values");
=20=20
DATA(insert OID =3D 2107 ( sum PGNSP PGUID 12 1 0 t f f f i 1 1700
"2=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as numeric across all bigint input values");
DATA(insert OID =3D 2108 ( sum PGNSP PGUID 12 1 0 t f f f i 1 20
"23"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as bigint across all integer input values");
DATA(insert OID =3D 2109 ( sum PGNSP PGUID 12 1 0 t f f f i 1 20
"21"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as bigint across all smallint input values");
DATA(insert OID =3D 2110 ( sum PGNSP PGUID 12 1 0 t f f f i 1 700
"70=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as float4 across all float4 input values");
DATA(insert OID =3D 2111 ( sum PGNSP PGUID 12 1 0 t f f f i 1 701
"70=
1" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as float8 across all float8 input values");
DATA(insert OID =3D 2112 ( sum PGNSP PGUID 12 1 0 t f f f i 1 790
"79=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as money across all money input values");
DATA(insert OID =3D 2113 ( sum PGNSP PGUID 12 1 0 t f f f i 1 1186
"1=
186" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as interval across all interval input values");
DATA(insert OID =3D 2114 ( sum PGNSP PGUID 12 1 0 t f f f i 1 1700
"1=
700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum as numeric across all numeric input values");
=20=20
DATA(insert OID =3D 2115 ( max PGNSP PGUID 12 1 0 t f f f i 1 20
"20"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all bigint input values");
DATA(insert OID =3D 2116 ( max PGNSP PGUID 12 1 0 t f f f i 1 23
"23"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all integer input values");
DATA(insert OID =3D 2117 ( max PGNSP PGUID 12 1 0 t f f f i 1 21
"21"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all smallint input values");
DATA(insert OID =3D 2118 ( max PGNSP PGUID 12 1 0 t f f f i 1 26
"26"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all oid input values");
DATA(insert OID =3D 2119 ( max PGNSP PGUID 12 1 0 t f f f i 1 700
"70=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all float4 input values");
DATA(insert OID =3D 2120 ( max PGNSP PGUID 12 1 0 t f f f i 1 701
"70=
1" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all float8 input values");
DATA(insert OID =3D 2121 ( max PGNSP PGUID 12 1 0 t f f f i 1 702
"70=
2" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all abstime input values");
DATA(insert OID =3D 2122 ( max PGNSP PGUID 12 1 0 t f f f i 1 1082
"1=
082" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all date input values");
DATA(insert OID =3D 2123 ( max PGNSP PGUID 12 1 0 t f f f i 1 1083
"1=
083" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all time input values");
DATA(insert OID =3D 2124 ( max PGNSP PGUID 12 1 0 t f f f i 1 1266
"1=
266" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all time with time zone input values");
DATA(insert OID =3D 2125 ( max PGNSP PGUID 12 1 0 t f f f i 1 790
"79=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all money input values");
DATA(insert OID =3D 2126 ( max PGNSP PGUID 12 1 0 t f f f i 1 1114
"1=
114" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all timestamp input values");
DATA(insert OID =3D 2127 ( max PGNSP PGUID 12 1 0 t f f f i 1 1184
"1=
184" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all timestamp with time zone input values");
DATA(insert OID =3D 2128 ( max PGNSP PGUID 12 1 0 t f f f i 1 1186
"1=
186" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all interval input values");
DATA(insert OID =3D 2129 ( max PGNSP PGUID 12 1 0 t f f f i 1 25
"25"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all text input values");
DATA(insert OID =3D 2130 ( max PGNSP PGUID 12 1 0 t f f f i 1 1700
"1=
700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all numeric input values");
DATA(insert OID =3D 2050 ( max PGNSP PGUID 12 1 0 t f f f i 1 2277
"2=
277" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all anyarray input values");
DATA(insert OID =3D 2244 ( max PGNSP PGUID 12 1 0 t f f f i 1 1042
"1=
042" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all bpchar input values");
DATA(insert OID =3D 2797 ( max PGNSP PGUID 12 1 0 t f f f i 1 27
"27"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum value of all tid input values");
=20=20
DATA(insert OID =3D 2131 ( min PGNSP PGUID 12 1 0 t f f f i 1 20
"20"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all bigint input values");
DATA(insert OID =3D 2132 ( min PGNSP PGUID 12 1 0 t f f f i 1 23
"23"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all integer input values");
DATA(insert OID =3D 2133 ( min PGNSP PGUID 12 1 0 t f f f i 1 21
"21"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all smallint input values");
DATA(insert OID =3D 2134 ( min PGNSP PGUID 12 1 0 t f f f i 1 26
"26"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all oid input values");
DATA(insert OID =3D 2135 ( min PGNSP PGUID 12 1 0 t f f f i 1 700
"70=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all float4 input values");
DATA(insert OID =3D 2136 ( min PGNSP PGUID 12 1 0 t f f f i 1 701
"70=
1" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all float8 input values");
DATA(insert OID =3D 2137 ( min PGNSP PGUID 12 1 0 t f f f i 1 702
"70=
2" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all abstime input values");
DATA(insert OID =3D 2138 ( min PGNSP PGUID 12 1 0 t f f f i 1 1082
"1=
082" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all date input values");
DATA(insert OID =3D 2139 ( min PGNSP PGUID 12 1 0 t f f f i 1 1083
"1=
083" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all time input values");
DATA(insert OID =3D 2140 ( min PGNSP PGUID 12 1 0 t f f f i 1 1266
"1=
266" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all time with time zone input values");
DATA(insert OID =3D 2141 ( min PGNSP PGUID 12 1 0 t f f f i 1 790
"79=
0" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all money input values");
DATA(insert OID =3D 2142 ( min PGNSP PGUID 12 1 0 t f f f i 1 1114
"1=
114" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all timestamp input values");
DATA(insert OID =3D 2143 ( min PGNSP PGUID 12 1 0 t f f f i 1 1184
"1=
184" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all timestamp with time zone input values");
DATA(insert OID =3D 2144 ( min PGNSP PGUID 12 1 0 t f f f i 1 1186
"1=
186" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all interval input values");
DATA(insert OID =3D 2145 ( min PGNSP PGUID 12 1 0 t f f f i 1 25
"25"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all text values");
DATA(insert OID =3D 2146 ( min PGNSP PGUID 12 1 0 t f f f i 1 1700
"1=
700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all numeric input values");
DATA(insert OID =3D 2051 ( min PGNSP PGUID 12 1 0 t f f f i 1 2277
"2=
277" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all anyarray input values");
DATA(insert OID =3D 2245 ( min PGNSP PGUID 12 1 0 t f f f i 1 1042
"1=
042" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all bpchar input values");
DATA(insert OID =3D 2798 ( min PGNSP PGUID 12 1 0 t f f f i 1 27
"27"=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum value of all tid input values");
=20=20
/* count has two forms: count(any) and count(*) */
DATA(insert OID =3D 2147 ( count PGNSP PGUID 12 1 0 t f f f i 1 20
"2=
276" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("number of input rows for which the input expression is not
null");
DATA(insert OID =3D 2803 ( count PGNSP PGUID 12 1 0 t f f f i 0 20
""=
_null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("number of input rows");
=20=20
DATA(insert OID =3D 2718 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1
1700=
"20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of bigint input values (square of the
populati=
on standard deviation)");
DATA(insert OID =3D 2719 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1
1700=
"23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of integer input values (square of the
populat=
ion standard deviation)");
DATA(insert OID =3D 2720 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1
1700=
"21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of smallint input values (square of the
popula=
tion standard deviation)");
DATA(insert OID =3D 2721 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1 701
=
"700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of float4 input values (square of the
populati=
on standard deviation)");
DATA(insert OID =3D 2722 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1 701
=
"701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of float8 input values (square of the
populati=
on standard deviation)");
DATA(insert OID =3D 2723 ( var_pop PGNSP PGUID 12 1 0 t f f f i 1
1700=
"1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population variance of numeric input values (square of the
populat=
ion standard deviation)");
=20=20
DATA(insert OID =3D 2641 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of bigint input values (square of the sample
stand=
ard deviation)");
DATA(insert OID =3D 2642 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of integer input values (square of the sample
stan=
dard deviation)");
DATA(insert OID =3D 2643 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of smallint input values (square of the sample
sta=
ndard deviation)");
+=20
DATA(insert OID =3D 2644 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
701=
"700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of float4 input values (square of the sample
stand=
ard deviation)");
DATA(insert OID =3D 2645 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
701=
"701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of float8 input values (square of the sample
stand=
ard deviation)");
DATA(insert OID =3D 2646 ( var_samp PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample variance of numeric input values (square of the sample
stan=
dard deviation)");
=20=20
DATA(insert OID =3D 2148 ( variance PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
DATA(insert OID =3D 2149 ( variance PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
DATA(insert OID =3D 2150 ( variance PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
DATA(insert OID =3D 2151 ( variance PGNSP PGUID 12 1 0 t f f f i 1
701=
"700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
DATA(insert OID =3D 2152 ( variance PGNSP PGUID 12 1 0 t f f f i 1
701=
"701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
DATA(insert OID =3D 2153 ( variance PGNSP PGUID 12 1 0 t f f f i 1
170=
0 "1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for var_samp");
=20=20
DATA(insert OID =3D 2724 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
17=
00 "20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of bigint input values");
DATA(insert OID =3D 2725 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
17=
00 "23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of integer input values");
DATA(insert OID =3D 2726 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
17=
00 "21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of smallint input values");
DATA(insert OID =3D 2727 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
70=
1 "700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of float4 input values");
DATA(insert OID =3D 2728 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
70=
1 "701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of float8 input values");
DATA(insert OID =3D 2729 ( stddev_pop PGNSP PGUID 12 1 0 t f f f i 1
17=
00 "1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population standard deviation of numeric input values");
=20=20
DATA(insert OID =3D 2712 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
1=
700 "20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of bigint input values");
DATA(insert OID =3D 2713 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
1=
700 "23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of integer input values");
DATA(insert OID =3D 2714 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
1=
700 "21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of smallint input values");
DATA(insert OID =3D 2715 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
7=
01 "700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of float4 input values");
DATA(insert OID =3D 2716 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
7=
01 "701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of float8 input values");
DATA(insert OID =3D 2717 ( stddev_samp PGNSP PGUID 12 1 0 t f f f i 1
1=
700 "1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample standard deviation of numeric input values");
=20=20
DATA(insert OID =3D 2154 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 1700
=
"20" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
DATA(insert OID =3D 2155 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 1700
=
"23" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
DATA(insert OID =3D 2156 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 1700
=
"21" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
DATA(insert OID =3D 2157 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 701
"=
700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
DATA(insert OID =3D 2158 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 701
"=
701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
DATA(insert OID =3D 2159 ( stddev PGNSP PGUID 12 1 0 t f f f i 1 1700
=
"1700" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("historical alias for stddev_samp");
=20=20
DATA(insert OID =3D 2818 ( regr_count PGNSP PGUID 12 1 0 t f f f i 2
20=
"701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("number of input rows in which both expressions are nonnull");
DATA(insert OID =3D 2819 ( regr_sxx PGNSP PGUID 12 1 0 t f f f i 2
701=
"701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum of squares of the independent variable (sum(X^2) -
sum(X)^2/N)=
");
DATA(insert OID =3D 2820 ( regr_syy PGNSP PGUID 12 1 0 t f f f i 2
701=
"701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum of squares of the dependent variable (sum(Y^2) -
sum(Y)^2/N)");
DATA(insert OID =3D 2821 ( regr_sxy PGNSP PGUID 12 1 0 t f f f i 2
701=
"701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sum of products of independent times dependent variable (sum(X*Y)
=
- sum(X) * sum(Y)/N)");
DATA(insert OID =3D 2822 ( regr_avgx PGNSP PGUID 12 1 0 t f f f i 2
70=
1 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("average of the independent variable (sum(X)/N)");
DATA(insert OID =3D 2823 ( regr_avgy PGNSP PGUID 12 1 0 t f f f i 2
70=
1 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("average of the dependent variable (sum(Y)/N)");
DATA(insert OID =3D 2824 ( regr_r2 PGNSP PGUID 12 1 0 t f f f i 2 701
=
"701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("square of the correlation coefficient");
DATA(insert OID =3D 2825 ( regr_slope PGNSP PGUID 12 1 0 t f f f i 2
70=
1 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("slope of the least-squares-fit linear equation determined by the
(=
X, Y) pairs");
DATA(insert OID =3D 2826 ( regr_intercept PGNSP PGUID 12 1 0 t f f f i
2=
701 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("y-intercept of the least-squares-fit linear equation determined
by=
the (X, Y) pairs");
=20=20
DATA(insert OID =3D 2827 ( covar_pop PGNSP PGUID 12 1 0 t f f f i 2
70=
1 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("population covariance");
DATA(insert OID =3D 2828 ( covar_samp PGNSP PGUID 12 1 0 t f f f i 2
70=
1 "701 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("sample covariance");
DATA(insert OID =3D 2829 ( corr PGNSP PGUID 12 1 0 t f f f i 2 701
"7=
01 701" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("correlation coefficient");
=20=20
DATA(insert OID =3D 2160 ( text_pattern_lt PGNSP PGUID 12 1 0 f f t f i
=
2 16 "25 25" _null_ _null_ _null_ text_pattern_lt - _null_ _null_ ));
DATA(insert OID =3D 2161 ( text_pattern_le PGNSP PGUID 12 1 0 f f t f i
=
2 16 "25 25" _null_ _null_ _null_ text_pattern_le - _null_ _null_ ));
***************
*** 4172,4182 ****
--- 4276,4292 ----
DATA(insert OID =3D 3525 ( enum_larger PGNSP PGUID 12 1 0 f f t f i 2
35=
00 "3500 3500" _null_ _null_ _null_ enum_larger - _null_ _null_ ));
DESCR("larger of two");
DATA(insert OID =3D 3526 ( max PGNSP PGUID 12 1 0 t f f f i 1 3500
"35=
00" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("maximum of anyenum");
DATA(insert OID =3D 3527 ( min PGNSP PGUID 12 1 0 t f f f i 1 3500
"35=
00" _null_ _null_ _null_ aggregate_dummy - _null_ _null_ ));
+ DESCR("minimum of anyenum");
DATA(insert OID =3D 3528 ( enum_first PGNSP PGUID 12 1 0 f f f f s 1
350=
0 "3500" _null_ _null_ _null_ enum_first - _null_ _null_ ));
+ DESCR("returns the first value of the input enum type");
DATA(insert OID =3D 3529 ( enum_last PGNSP PGUID 12 1 0 f f f f s 1
350=
0 "3500" _null_ _null_ _null_ enum_last - _null_ _null_ ));
+ DESCR("returns the last value of the input enum type");
DATA(insert OID =3D 3530 ( enum_range PGNSP PGUID 12 1 0 f f f f s 2
227=
7 "3500 3500" _null_ _null_ _null_ enum_range_bounds - _null_ _null_ ));
+ DESCR("returns the range between the two given enum values, as an
ordered=
array");
DATA(insert OID =3D 3531 ( enum_range PGNSP PGUID 12 1 0 f f f f s 1
227=
7 "3500" _null_ _null_ _null_ enum_range_all - _null_ _null_ ));
+ DESCR("returns the range of the given enum type as an ordered array");
DATA(insert OID =3D 3532 ( enum_recv PGNSP PGUID 12 1 0 f f t f s 2
350=
0 "2275 26" _null_ _null_ _null_ enum_recv - _null_ _null_ ));
DATA(insert OID =3D 3533 ( enum_send PGNSP PGUID 12 1 0 f f t f s 1
17 =
"3500" _null_ _null_ _null_ enum_send - _null_ _null_ ));
=20=20
--==========BAF5C2B261E75ECA6438==========
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
--
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
--==========BAF5C2B261E75ECA6438==========--
|
