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[])
correlation_result	correlation (varchar source_table, varchar output_table, varchar target_cols, boolean verbose)
correlation_result	correlation (varchar source_table, varchar output_table, varchar target_cols)
correlation_result	correlation (varchar source_table, varchar output_table)
text	correlation (text input_message)
text	correlation ()

Detailed Description

Date

April 2013

See also

For a brief introduction to correlation, see the module description Pearson's Correlation

Function Documentation

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

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

correlation_result correlation	(	varchar	source_table,
		varchar	output_table
	)

text correlation

(

text

input_message

)

text correlation

(

)

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

float8 [] correlation_final

(

float8[]

state

)

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

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