SQL functions for correlation computation.
More...
|
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) |
|
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) |
|
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 () |
|
- Date
- April 2013
- See also
- For a brief introduction to correlation, see the module description Pearson's Correlation
◆ correlation() [1/5]
text correlation |
( |
varchar |
source_table, |
|
|
varchar |
output_table, |
|
|
varchar |
target_cols, |
|
|
boolean |
verbose |
|
) |
| |
◆ correlation() [2/5]
text correlation |
( |
varchar |
source_table, |
|
|
varchar |
output_table, |
|
|
varchar |
target_cols |
|
) |
| |
◆ correlation() [3/5]
text correlation |
( |
varchar |
source_table, |
|
|
varchar |
output_table |
|
) |
| |
◆ correlation() [4/5]
text correlation |
( |
text |
input_message | ) |
|
◆ correlation() [5/5]
◆ 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/5]
text covariance |
( |
varchar |
source_table, |
|
|
varchar |
output_table, |
|
|
varchar |
target_cols, |
|
|
boolean |
verbose |
|
) |
| |
◆ covariance() [2/5]
text covariance |
( |
varchar |
source_table, |
|
|
varchar |
output_table, |
|
|
varchar |
target_cols |
|
) |
| |
◆ covariance() [3/5]
text covariance |
( |
varchar |
source_table, |
|
|
varchar |
output_table |
|
) |
| |
◆ covariance() [4/5]
text covariance |
( |
text |
input_message | ) |
|
◆ covariance() [5/5]
◆ covariance_agg()
aggregate float8 [] covariance_agg |
( |
float8 |
[], |
|
|
float8 |
[] |
|
) |
| |