correlation.sql_in File Reference

SQL functions for correlation computation. More...

Functions
float8 []	correlation_transition (float8[] state, float8[] x, float8[] mean)
float8 []	correlation_merge (float8[] left_state, float8[] right_state)
float8 []	correlation_final (float8[] state)
aggregate float8 []	correlation_agg (float8[], float8[])
aggregate float8 []	covariance_agg (float8[], float8[])
text	correlation (varchar source_table, varchar output_table, varchar target_cols, boolean verbose, varchar grouping_cols, integer n_groups_per_run)
text	correlation (varchar source_table, varchar output_table, varchar target_cols, boolean verbose, varchar grouping_cols)
text	correlation (varchar source_table, varchar output_table, varchar target_cols, boolean verbose)
text	correlation (varchar source_table, varchar output_table, varchar target_cols)
text	correlation (varchar source_table, varchar output_table)
text	correlation (text input_message)
text	correlation ()
text	covariance (varchar source_table, varchar output_table, varchar target_cols, boolean verbose, varchar grouping_cols, integer n_groups_per_run)
text	covariance (varchar source_table, varchar output_table, varchar target_cols, boolean verbose, varchar grouping_cols)
text	covariance (varchar source_table, varchar output_table, varchar target_cols, boolean verbose)
text	covariance (varchar source_table, varchar output_table, varchar target_cols)
text	covariance (varchar source_table, varchar output_table)
text	covariance (text input_message)
text	covariance ()

Detailed Description

Date

April 2013

See also

For a brief introduction to correlation, see the module description Covariance and Correlation

Function Documentation

correlation() [1/7]

text correlation	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose,
		varchar	grouping_cols,
		integer	n_groups_per_run
	)

correlation() [2/7]

text correlation	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose,
		varchar	grouping_cols
	)

correlation() [3/7]

text correlation	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose
	)

correlation() [4/7]

text correlation	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols
	)

correlation() [5/7]

text correlation	(	varchar	source_table,
		varchar	output_table
	)

correlation() [6/7]

text correlation

(

text

input_message

)

correlation() [7/7]

text correlation

(

)

correlation_agg()

aggregate float8 [] correlation_agg	(	float8	[],
		float8	[]
	)

correlation_final()

float8 [] correlation_final

(

float8 []

state

)

correlation_merge()

float8 [] correlation_merge	(	float8 []	left_state,
		float8 []	right_state
	)

correlation_transition()

float8 [] correlation_transition	(	float8 []	state,
		float8 []	x,
		float8 []	mean
	)

covariance() [1/7]

text covariance	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose,
		varchar	grouping_cols,
		integer	n_groups_per_run
	)

covariance() [2/7]

text covariance	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose,
		varchar	grouping_cols
	)

covariance() [3/7]

text covariance	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols,
		boolean	verbose
	)

covariance() [4/7]

text covariance	(	varchar	source_table,
		varchar	output_table,
		varchar	target_cols
	)

covariance() [5/7]

text covariance	(	varchar	source_table,
		varchar	output_table
	)

covariance() [6/7]

text covariance

(

text

input_message

)

covariance() [7/7]

text covariance

(

)

covariance_agg()

aggregate float8 [] covariance_agg	(	float8	[],
		float8	[]
	)