Commit9201043

Jan Wieck

authored and

Jan Wieck

committed

New contrib module for statistical mathematics

Jan

1 parent500b62b commit9201043Copy full SHA for 9201043

File tree

+492

-0

lines changed

+492

-0

lines changed

Lines changed: 58 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,58 @@`
	`1`	`+#`
	`2`	`+# $Header: /cvsroot/pgsql/contrib/statmath/Attic/Makefile,v 1.1 2000/07/04 14:36:03 wieck Exp $`
	`3`	`+#`
	`4`	`+`
	`5`	`+TOPDIR=../..`
	`6`	`+`
	`7`	`+include ../Makefile.global`
	`8`	`+`
	`9`	`+NAME= statmath`
	`10`	`+`
	`11`	`+PROGRAM=`
	`12`	`+OBJS=$(NAME).o`
	`13`	`+DOCS= README.$(NAME)`
	`14`	`+SQLS=$(NAME).sql`
	`15`	`+BINS=`
	`16`	`+EXAMPLES=`
	`17`	`+MODS=$(NAME)$(DLSUFFIX)`
	`18`	`+`
	`19`	`+CFLAGS += -I.$(CFLAGS_SL)`
	`20`	`+`
	`21`	`+OTHER_CLEAN =$(SQLS)`
	`22`	`+`
	`23`	`+all:$(MODS)$(SQLS)`
	`24`	`+`
	`25`	`+%.sql:%.sql.in`
	`26`	`+$(SED)"s\|MODULE_PATHNAME\|$(CONTRIB_MODDIR)/$(NAME)$(DLSUFFIX)\|"<$<>$@`
	`27`	`+`
	`28`	`+install: install_doc install_sql install_mod install_bin`
	`29`	`+`
	`30`	`+install_doc:`
	`31`	`+forinst_filein$(DOCS);do \`
	`32`	`+$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file$(CONTRIB_DOCDIR);\`
	`33`	`+done`
	`34`	`+`
	`35`	`+install_sql:`
	`36`	`+forinst_filein$(SQLS);do \`
	`37`	`+$(INSTALL)$(INSTL_LIB_OPTS)$$inst_file$(CONTRIB_SQLDIR);\`
	`38`	`+done`
	`39`	`+`
	`40`	`+install_mod:`
	`41`	`+forinst_filein$(MODS);do \`
	`42`	`+$(INSTALL)$(INSTL_SHLIB_OPTS)$$inst_file$(CONTRIB_MODDIR);\`
	`43`	`+done`
	`44`	`+`
	`45`	`+install_bin:`
	`46`	`+forinst_filein$(BINS);do \`
	`47`	`+$(INSTALL)$(INSTL_EXE_OPTS)$$inst_file$(CONTRIB_BINDIR);\`
	`48`	`+done`
	`49`	`+`
	`50`	`+dependdep:`
	`51`	`+$(CC) -MM -MG$(CFLAGS)*.c> depend`
	`52`	`+`
	`53`	`+clean:`
	`54`	`+$(RM)*~$(OBJS)$(MODS)$(PROGRAM) depend$(OTHER_CLEAN) core log`
	`55`	`+`
	`56`	`+ifeq (depend,$(wildcard depend))`
	`57`	`+include depend`
	`58`	`+endif`

Lines changed: 39 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,39 @@`
	`1`	`+Statistical aggregate functions for PostgreSQL.`
	`2`	`+`
	`3`	`+This module provides some aggregate functions for statistical`
	`4`	`+mathematics. A new datatype holding two double precision`
	`5`	`+floating point values is required by them.`
	`6`	`+`
	`7`	`+The aggregates are:`
	`8`	`+`
	`9`	`+average(float8) average value computed by`
	`10`	`+`
	`11`	`+ n`
	`12`	`+ ___`
	`13`	`+ _ 1 \`
	`14`	`+ x = --- > x`
	`15`	`+ n /__ i`
	`16`	`+ i=1`
	`17`	`+`
	`18`	`+`
	`19`	`+variance(float8 variance computed by`
	`20`	`+`
	`21`	`+ n`
	`22`	`+ ___`
	`23`	`+ 2 1 \ _ 2`
	`24`	`+ s = --- > (x - x)`
	`25`	`+ n-1 /__ i`
	`26`	`+ i=1`
	`27`	`+`
	`28`	`+`
	`29`	`+`
	`30`	`+stddev(float8) standard deviation computed by`
	`31`	`+`
	`32`	`+ _____`
	`33`	`+ / 2`
	`34`	`+ s = / s`
	`35`	`+ \/`
	`36`	`+`
	`37`	`+`
	`38`	`+--`
	`39`	`+Jan Wieck <JanWieck@Yahoo.com>`

Comments

(0)