12 m4_include(`SQLCommon.m4
')
116 CREATE FUNCTION MADLIB_SCHEMA.bernoulli_cdf(
119 ) RETURNS DOUBLE PRECISION
133 CREATE FUNCTION MADLIB_SCHEMA.bernoulli_pmf(
136 ) RETURNS DOUBLE PRECISION
148 CREATE FUNCTION MADLIB_SCHEMA.bernoulli_quantile(
151 ) RETURNS DOUBLE PRECISION
166 CREATE FUNCTION MADLIB_SCHEMA.beta_cdf(
168 alpha DOUBLE PRECISION,
169 beta DOUBLE PRECISION
170 ) RETURNS DOUBLE PRECISION
185 CREATE FUNCTION MADLIB_SCHEMA.beta_pdf(
187 alpha DOUBLE PRECISION,
188 beta DOUBLE PRECISION
189 ) RETURNS DOUBLE PRECISION
204 CREATE FUNCTION MADLIB_SCHEMA.beta_quantile(
206 alpha DOUBLE PRECISION,
207 beta DOUBLE PRECISION
208 ) RETURNS DOUBLE PRECISION
224 CREATE FUNCTION MADLIB_SCHEMA.binomial_cdf(
228 ) RETURNS DOUBLE PRECISION
243 CREATE FUNCTION MADLIB_SCHEMA.binomial_pmf(
247 ) RETURNS DOUBLE PRECISION
264 CREATE FUNCTION MADLIB_SCHEMA.binomial_quantile(
268 ) RETURNS DOUBLE PRECISION
284 CREATE FUNCTION MADLIB_SCHEMA.cauchy_cdf(
286 location DOUBLE PRECISION,
287 scale DOUBLE PRECISION
288 ) RETURNS DOUBLE PRECISION
303 CREATE FUNCTION MADLIB_SCHEMA.cauchy_pdf(
305 location DOUBLE PRECISION,
306 scale DOUBLE PRECISION
307 ) RETURNS DOUBLE PRECISION
322 CREATE FUNCTION MADLIB_SCHEMA.cauchy_quantile(
324 location DOUBLE PRECISION,
325 scale DOUBLE PRECISION
326 ) RETURNS DOUBLE PRECISION
340 CREATE FUNCTION MADLIB_SCHEMA.chi_squared_cdf(
343 ) RETURNS DOUBLE PRECISION
357 CREATE FUNCTION MADLIB_SCHEMA.chi_squared_pdf(
360 ) RETURNS DOUBLE PRECISION
374 CREATE FUNCTION MADLIB_SCHEMA.chi_squared_quantile(
377 ) RETURNS DOUBLE PRECISION
391 CREATE FUNCTION MADLIB_SCHEMA.exponential_cdf(
393 lambda DOUBLE PRECISION
394 ) RETURNS DOUBLE PRECISION
408 CREATE FUNCTION MADLIB_SCHEMA.exponential_pdf(
410 lambda DOUBLE PRECISION
411 ) RETURNS DOUBLE PRECISION
425 CREATE FUNCTION MADLIB_SCHEMA.exponential_quantile(
427 lambda DOUBLE PRECISION
428 ) RETURNS DOUBLE PRECISION
444 CREATE FUNCTION MADLIB_SCHEMA.extreme_value_cdf(
446 location DOUBLE PRECISION,
447 scale DOUBLE PRECISION
448 ) RETURNS DOUBLE PRECISION
463 CREATE FUNCTION MADLIB_SCHEMA.extreme_value_pdf(
465 location DOUBLE PRECISION,
466 scale DOUBLE PRECISION
467 ) RETURNS DOUBLE PRECISION
482 CREATE FUNCTION MADLIB_SCHEMA.extreme_value_quantile(
484 location DOUBLE PRECISION,
485 scale DOUBLE PRECISION
486 ) RETURNS DOUBLE PRECISION
501 CREATE FUNCTION MADLIB_SCHEMA.fisher_f_cdf(
503 df1 DOUBLE PRECISION,
505 ) RETURNS DOUBLE PRECISION
520 CREATE FUNCTION MADLIB_SCHEMA.fisher_f_pdf(
522 df1 DOUBLE PRECISION,
524 ) RETURNS DOUBLE PRECISION
539 CREATE FUNCTION MADLIB_SCHEMA.fisher_f_quantile(
541 df1 DOUBLE PRECISION,
543 ) RETURNS DOUBLE PRECISION
559 CREATE FUNCTION MADLIB_SCHEMA.gamma_cdf(
561 shape DOUBLE PRECISION,
562 scale DOUBLE PRECISION
563 ) RETURNS DOUBLE PRECISION
578 CREATE FUNCTION MADLIB_SCHEMA.gamma_pdf(
580 shape DOUBLE PRECISION,
581 scale DOUBLE PRECISION
582 ) RETURNS DOUBLE PRECISION
597 CREATE FUNCTION MADLIB_SCHEMA.gamma_quantile(
599 shape DOUBLE PRECISION,
600 scale DOUBLE PRECISION
601 ) RETURNS DOUBLE PRECISION
615 CREATE FUNCTION MADLIB_SCHEMA.geometric_cdf(
618 ) RETURNS DOUBLE PRECISION
632 CREATE FUNCTION MADLIB_SCHEMA.geometric_pmf(
635 ) RETURNS DOUBLE PRECISION
651 CREATE FUNCTION MADLIB_SCHEMA.geometric_quantile(
654 ) RETURNS DOUBLE PRECISION
676 CREATE FUNCTION MADLIB_SCHEMA.hypergeometric_cdf(
681 ) RETURNS DOUBLE PRECISION
700 CREATE FUNCTION MADLIB_SCHEMA.hypergeometric_pmf(
705 ) RETURNS DOUBLE PRECISION
725 CREATE FUNCTION MADLIB_SCHEMA.hypergeometric_quantile(
730 ) RETURNS DOUBLE PRECISION
746 CREATE FUNCTION MADLIB_SCHEMA.inverse_gamma_cdf(
748 shape DOUBLE PRECISION,
749 scale DOUBLE PRECISION
750 ) RETURNS DOUBLE PRECISION
765 CREATE FUNCTION MADLIB_SCHEMA.inverse_gamma_pdf(
767 shape DOUBLE PRECISION,
768 scale DOUBLE PRECISION
769 ) RETURNS DOUBLE PRECISION
784 CREATE FUNCTION MADLIB_SCHEMA.inverse_gamma_quantile(
786 shape DOUBLE PRECISION,
787 scale DOUBLE PRECISION
788 ) RETURNS DOUBLE PRECISION
803 CREATE FUNCTION MADLIB_SCHEMA.kolmogorov_cdf(
805 ) RETURNS DOUBLE PRECISION
820 CREATE FUNCTION MADLIB_SCHEMA.laplace_cdf(
822 mean DOUBLE PRECISION,
823 scale DOUBLE PRECISION
824 ) RETURNS DOUBLE PRECISION
839 CREATE FUNCTION MADLIB_SCHEMA.laplace_pdf(
841 mean DOUBLE PRECISION,
842 scale DOUBLE PRECISION
843 ) RETURNS DOUBLE PRECISION
858 CREATE FUNCTION MADLIB_SCHEMA.laplace_quantile(
860 mean DOUBLE PRECISION,
861 scale DOUBLE PRECISION
862 ) RETURNS DOUBLE PRECISION
877 CREATE FUNCTION MADLIB_SCHEMA.logistic_cdf(
879 mean DOUBLE PRECISION,
880 scale DOUBLE PRECISION
881 ) RETURNS DOUBLE PRECISION
896 CREATE FUNCTION MADLIB_SCHEMA.logistic_pdf(
898 mean DOUBLE PRECISION,
899 scale DOUBLE PRECISION
900 ) RETURNS DOUBLE PRECISION
915 CREATE FUNCTION MADLIB_SCHEMA.logistic_quantile(
917 mean DOUBLE PRECISION,
918 scale DOUBLE PRECISION
919 ) RETURNS DOUBLE PRECISION
935 CREATE FUNCTION MADLIB_SCHEMA.lognormal_cdf(
937 location DOUBLE PRECISION,
938 scale DOUBLE PRECISION
939 ) RETURNS DOUBLE PRECISION
954 CREATE FUNCTION MADLIB_SCHEMA.lognormal_pdf(
956 location DOUBLE PRECISION,
957 scale DOUBLE PRECISION
958 ) RETURNS DOUBLE PRECISION
973 CREATE FUNCTION MADLIB_SCHEMA.lognormal_quantile(
975 location DOUBLE PRECISION,
976 scale DOUBLE PRECISION
977 ) RETURNS DOUBLE PRECISION
993 CREATE FUNCTION MADLIB_SCHEMA.negative_binomial_cdf(
997 ) RETURNS DOUBLE PRECISION
1013 CREATE FUNCTION MADLIB_SCHEMA.negative_binomial_pmf(
1017 ) RETURNS DOUBLE PRECISION
1018 AS 'MODULE_PATHNAME
'
1035 CREATE FUNCTION MADLIB_SCHEMA.negative_binomial_quantile(
1039 ) RETURNS DOUBLE PRECISION
1040 AS 'MODULE_PATHNAME
'
1056 CREATE FUNCTION MADLIB_SCHEMA.non_central_beta_cdf(
1058 alpha DOUBLE PRECISION,
1059 beta DOUBLE PRECISION,
1060 ncp DOUBLE PRECISION
1061 ) RETURNS DOUBLE PRECISION
1062 AS 'MODULE_PATHNAME
'
1078 CREATE FUNCTION MADLIB_SCHEMA.non_central_beta_pdf(
1080 alpha DOUBLE PRECISION,
1081 beta DOUBLE PRECISION,
1082 ncp DOUBLE PRECISION
1083 ) RETURNS DOUBLE PRECISION
1084 AS 'MODULE_PATHNAME
'
1100 CREATE FUNCTION MADLIB_SCHEMA.non_central_beta_quantile(
1102 alpha DOUBLE PRECISION,
1103 beta DOUBLE PRECISION,
1104 ncp DOUBLE PRECISION
1105 ) RETURNS DOUBLE PRECISION
1106 AS 'MODULE_PATHNAME
'
1121 CREATE FUNCTION MADLIB_SCHEMA.non_central_chi_squared_cdf(
1123 df DOUBLE PRECISION,
1124 ncp DOUBLE PRECISION
1125 ) RETURNS DOUBLE PRECISION
1126 AS 'MODULE_PATHNAME
'
1140 CREATE FUNCTION MADLIB_SCHEMA.non_central_chi_squared_pdf(
1142 df DOUBLE PRECISION,
1143 ncp DOUBLE PRECISION
1144 ) RETURNS DOUBLE PRECISION
1145 AS 'MODULE_PATHNAME
'
1159 CREATE FUNCTION MADLIB_SCHEMA.non_central_chi_squared_quantile(
1161 df DOUBLE PRECISION,
1162 ncp DOUBLE PRECISION
1163 ) RETURNS DOUBLE PRECISION
1164 AS 'MODULE_PATHNAME
'
1180 CREATE FUNCTION MADLIB_SCHEMA.non_central_f_cdf(
1182 df1 DOUBLE PRECISION,
1183 df2 DOUBLE PRECISION,
1184 ncp DOUBLE PRECISION
1185 ) RETURNS DOUBLE PRECISION
1186 AS 'MODULE_PATHNAME
'
1201 CREATE FUNCTION MADLIB_SCHEMA.non_central_f_pdf(
1203 df1 DOUBLE PRECISION,
1204 df2 DOUBLE PRECISION,
1205 ncp DOUBLE PRECISION
1206 ) RETURNS DOUBLE PRECISION
1207 AS 'MODULE_PATHNAME
'
1222 CREATE FUNCTION MADLIB_SCHEMA.non_central_f_quantile(
1224 df1 DOUBLE PRECISION,
1225 df2 DOUBLE PRECISION,
1226 ncp DOUBLE PRECISION
1227 ) RETURNS DOUBLE PRECISION
1228 AS 'MODULE_PATHNAME
'
1243 CREATE FUNCTION MADLIB_SCHEMA.non_central_t_cdf(
1245 df DOUBLE PRECISION,
1246 ncp DOUBLE PRECISION
1247 ) RETURNS DOUBLE PRECISION
1248 AS 'MODULE_PATHNAME
'
1262 CREATE FUNCTION MADLIB_SCHEMA.non_central_t_pdf(
1264 df DOUBLE PRECISION,
1265 ncp DOUBLE PRECISION
1266 ) RETURNS DOUBLE PRECISION
1267 AS 'MODULE_PATHNAME
'
1281 CREATE FUNCTION MADLIB_SCHEMA.non_central_t_quantile(
1283 df DOUBLE PRECISION,
1284 ncp DOUBLE PRECISION
1285 ) RETURNS DOUBLE PRECISION
1286 AS 'MODULE_PATHNAME
'
1300 CREATE FUNCTION MADLIB_SCHEMA.normal_cdf(
1302 mean DOUBLE PRECISION /*+ DEFAULT 0 */,
1303 sd DOUBLE PRECISION /*+ DEFAULT 1 */
1304 ) RETURNS DOUBLE PRECISION
1305 AS 'MODULE_PATHNAME
'
1309 CREATE FUNCTION MADLIB_SCHEMA.normal_cdf(
1311 mean DOUBLE PRECISION
1312 ) RETURNS DOUBLE PRECISION
1316 SELECT MADLIB_SCHEMA.normal_cdf($1, $2, 1)
1319 CREATE FUNCTION MADLIB_SCHEMA.normal_cdf(
1321 ) RETURNS DOUBLE PRECISION
1325 SELECT MADLIB_SCHEMA.normal_cdf($1, 0, 1)
1338 CREATE FUNCTION MADLIB_SCHEMA.normal_pdf(
1340 mean DOUBLE PRECISION /*+ DEFAULT 0 */,
1341 sd DOUBLE PRECISION /*+ DEFAULT 1 */
1342 ) RETURNS DOUBLE PRECISION
1343 AS 'MODULE_PATHNAME
'
1347 CREATE FUNCTION MADLIB_SCHEMA.normal_pdf(
1349 mean DOUBLE PRECISION
1350 ) RETURNS DOUBLE PRECISION
1354 SELECT MADLIB_SCHEMA.normal_pdf($1, $2, 1)
1357 CREATE FUNCTION MADLIB_SCHEMA.normal_pdf(
1359 ) RETURNS DOUBLE PRECISION
1363 SELECT MADLIB_SCHEMA.normal_pdf($1, 0, 1)
1376 CREATE FUNCTION MADLIB_SCHEMA.normal_quantile(
1378 mean DOUBLE PRECISION /*+ DEFAULT 0 */,
1379 sd DOUBLE PRECISION /*+ DEFAULT 1 */
1380 ) RETURNS DOUBLE PRECISION
1381 AS 'MODULE_PATHNAME
'
1385 CREATE FUNCTION MADLIB_SCHEMA.normal_quantile(
1387 mean DOUBLE PRECISION
1388 ) RETURNS DOUBLE PRECISION
1392 SELECT MADLIB_SCHEMA.normal_quantile($1, $2, 1)
1395 CREATE FUNCTION MADLIB_SCHEMA.normal_quantile(
1397 ) RETURNS DOUBLE PRECISION
1401 SELECT MADLIB_SCHEMA.normal_quantile($1, 0, 1)
1415 CREATE FUNCTION MADLIB_SCHEMA.pareto_cdf(
1417 scale DOUBLE PRECISION,
1418 shape DOUBLE PRECISION
1419 ) RETURNS DOUBLE PRECISION
1420 AS 'MODULE_PATHNAME
'
1434 CREATE FUNCTION MADLIB_SCHEMA.pareto_pdf(
1436 scale DOUBLE PRECISION,
1437 shape DOUBLE PRECISION
1438 ) RETURNS DOUBLE PRECISION
1439 AS 'MODULE_PATHNAME
'
1453 CREATE FUNCTION MADLIB_SCHEMA.pareto_quantile(
1455 scale DOUBLE PRECISION,
1456 shape DOUBLE PRECISION
1457 ) RETURNS DOUBLE PRECISION
1458 AS 'MODULE_PATHNAME
'
1471 CREATE FUNCTION MADLIB_SCHEMA.poisson_cdf(
1473 mean DOUBLE PRECISION
1474 ) RETURNS DOUBLE PRECISION
1475 AS 'MODULE_PATHNAME
'
1487 CREATE FUNCTION MADLIB_SCHEMA.poisson_pmf(
1489 mean DOUBLE PRECISION
1490 ) RETURNS DOUBLE PRECISION
1491 AS 'MODULE_PATHNAME
'
1505 CREATE FUNCTION MADLIB_SCHEMA.poisson_quantile(
1507 mean DOUBLE PRECISION
1508 ) RETURNS DOUBLE PRECISION
1509 AS 'MODULE_PATHNAME
'
1522 CREATE FUNCTION MADLIB_SCHEMA.rayleigh_cdf(
1524 scale DOUBLE PRECISION
1525 ) RETURNS DOUBLE PRECISION
1526 AS 'MODULE_PATHNAME
'
1538 CREATE FUNCTION MADLIB_SCHEMA.rayleigh_pdf(
1540 scale DOUBLE PRECISION
1541 ) RETURNS DOUBLE PRECISION
1542 AS 'MODULE_PATHNAME
'
1554 CREATE FUNCTION MADLIB_SCHEMA.rayleigh_quantile(
1556 scale DOUBLE PRECISION
1557 ) RETURNS DOUBLE PRECISION
1558 AS 'MODULE_PATHNAME
'
1571 CREATE FUNCTION MADLIB_SCHEMA.students_t_cdf(
1574 ) RETURNS DOUBLE PRECISION
1575 AS 'MODULE_PATHNAME
'
1588 CREATE FUNCTION MADLIB_SCHEMA.students_t_pdf(
1591 ) RETURNS DOUBLE PRECISION
1592 AS 'MODULE_PATHNAME
'
1605 CREATE FUNCTION MADLIB_SCHEMA.students_t_quantile(
1608 ) RETURNS DOUBLE PRECISION
1609 AS 'MODULE_PATHNAME
'
1624 CREATE FUNCTION MADLIB_SCHEMA.triangular_cdf(
1626 lower DOUBLE PRECISION,
1627 mode DOUBLE PRECISION,
1628 upper DOUBLE PRECISION
1629 ) RETURNS DOUBLE PRECISION
1630 AS 'MODULE_PATHNAME
'
1644 CREATE FUNCTION MADLIB_SCHEMA.triangular_pdf(
1646 lower DOUBLE PRECISION,
1647 mode DOUBLE PRECISION,
1648 upper DOUBLE PRECISION
1649 ) RETURNS DOUBLE PRECISION
1650 AS 'MODULE_PATHNAME
'
1664 CREATE FUNCTION MADLIB_SCHEMA.triangular_quantile(
1666 lower DOUBLE PRECISION,
1667 mode DOUBLE PRECISION,
1668 upper DOUBLE PRECISION
1669 ) RETURNS DOUBLE PRECISION
1670 AS 'MODULE_PATHNAME
'
1684 CREATE FUNCTION MADLIB_SCHEMA.uniform_cdf(
1686 lower DOUBLE PRECISION,
1687 upper DOUBLE PRECISION
1688 ) RETURNS DOUBLE PRECISION
1689 AS 'MODULE_PATHNAME
'
1702 CREATE FUNCTION MADLIB_SCHEMA.uniform_pdf(
1704 lower DOUBLE PRECISION,
1705 upper DOUBLE PRECISION
1706 ) RETURNS DOUBLE PRECISION
1707 AS 'MODULE_PATHNAME
'
1720 CREATE FUNCTION MADLIB_SCHEMA.uniform_quantile(
1722 lower DOUBLE PRECISION,
1723 upper DOUBLE PRECISION
1724 ) RETURNS DOUBLE PRECISION
1725 AS 'MODULE_PATHNAME
'
1740 CREATE FUNCTION MADLIB_SCHEMA.weibull_cdf(
1742 shape DOUBLE PRECISION,
1743 scale DOUBLE PRECISION
1744 ) RETURNS DOUBLE PRECISION
1745 AS 'MODULE_PATHNAME
'
1759 CREATE FUNCTION MADLIB_SCHEMA.weibull_pdf(
1761 shape DOUBLE PRECISION,
1762 scale DOUBLE PRECISION
1763 ) RETURNS DOUBLE PRECISION
1764 AS 'MODULE_PATHNAME
'
1778 CREATE FUNCTION MADLIB_SCHEMA.weibull_quantile(
1780 shape DOUBLE PRECISION,
1781 scale DOUBLE PRECISION
1782 ) RETURNS DOUBLE PRECISION
1783 AS 'MODULE_PATHNAME
'