User Documentation
 All Files Functions Variables Groups
clustered_variance.sql_in File Reference

Functions

void clustered_variance_linregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col)
 Compute the clustered errors. More...
 
void clustered_variance_linregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar)
 
text clustered_variance_linregr ()
 
text clustered_variance_linregr (text msg)
 
bytea8 __clustered_err_lin_transition (bytea8 state, float8 y, float8[] x, float8[] coef)
 
bytea8 __clustered_err_lin_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_lin_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_lin_step (float8, float8[], float8[])
 
__clustered_lin_result __clustered_lin_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 
float8[] __array_add (float8[] x, float8[] y)
 
aggregate float8[] __array_sum (float8[])
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer, float8 tolerance, boolean verbose)
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar)
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col)
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter)
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer)
 
void clustered_variance_logregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer, float8 tolerance)
 
text clustered_variance_logregr ()
 
text clustered_variance_logregr (text msg)
 
bytea8 __clustered_err_log_transition (bytea8 state, boolean y, float8[] x, float8[] coef)
 
bytea8 __clustered_err_log_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_log_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_log_step (boolean, float8[], float8[])
 
__clustered_log_result __clustered_log_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category, text grouping_col, integer max_iter, text optimizer, float8 tolerance, boolean verbose)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category, text grouping_col)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category, text grouping_col, integer max_iter)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category, text grouping_col, integer max_iter, text optimizer)
 
void clustered_variance_mlogregr (text tbl_data, text tbl_output, text depvar, text indvar, text clustervar, integer ref_category, text grouping_col, integer max_iter, text optimizer, float8 tolerance)
 
text clustered_variance_mlogregr ()
 
text clustered_variance_mlogregr (text msg)
 
bytea8 __clustered_err_mlog_transition (bytea8 state, integer y, float8[] x, float8[] coef, integer num_cat, integer ref_cat)
 
bytea8 __clustered_err_mlog_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_mlog_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_mlog_step (integer, float8[], float8[], integer, integer)
 
__clustered_mlog_result __clustered_mlog_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 

Function Documentation

float8 [] __array_add ( float8[]  x,
float8[]  y 
)
aggregate float8 [] __array_sum ( float8  [])
__clustered_agg_result __clustered_err_lin_final ( bytea8  state)
bytea8 __clustered_err_lin_merge ( bytea8  state1,
bytea8  state2 
)
aggregate __clustered_agg_result __clustered_err_lin_step ( float8  ,
float8  [],
float8  [] 
)
bytea8 __clustered_err_lin_transition ( bytea8  state,
float8  y,
float8[]  x,
float8[]  coef 
)
__clustered_agg_result __clustered_err_log_final ( bytea8  state)
bytea8 __clustered_err_log_merge ( bytea8  state1,
bytea8  state2 
)
aggregate __clustered_agg_result __clustered_err_log_step ( boolean  ,
float8  [],
float8  [] 
)
bytea8 __clustered_err_log_transition ( bytea8  state,
boolean  y,
float8[]  x,
float8[]  coef 
)
__clustered_agg_result __clustered_err_mlog_final ( bytea8  state)
bytea8 __clustered_err_mlog_merge ( bytea8  state1,
bytea8  state2 
)
aggregate __clustered_agg_result __clustered_err_mlog_step ( integer  ,
float8  [],
float8  [],
integer  ,
integer   
)
bytea8 __clustered_err_mlog_transition ( bytea8  state,
integer  y,
float8[]  x,
float8[]  coef,
integer  num_cat,
integer  ref_cat 
)
__clustered_lin_result __clustered_lin_compute_stats ( float8[]  coef,
float8[]  meatvec,
float8[]  breadvec,
integer  mcluster,
integer  numrows 
)
__clustered_log_result __clustered_log_compute_stats ( float8[]  coef,
float8[]  meatvec,
float8[]  breadvec,
integer  mcluster,
integer  numrows 
)
__clustered_mlog_result __clustered_mlog_compute_stats ( float8[]  coef,
float8[]  meatvec,
float8[]  breadvec,
integer  mcluster,
integer  numrows 
)
void clustered_variance_linregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col 
)
Parameters
tbl_dataData table name
tbl_outputThe result table
depvarDependent variable expression
indvarIndependent variable expression
clustervarThe expressions used to clustering
grouping_colThe names of grouping columns
void clustered_variance_linregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar 
)
text clustered_variance_linregr ( )
text clustered_variance_linregr ( text  msg)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance,
boolean  verbose 
)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar 
)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col 
)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter 
)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer 
)
void clustered_variance_logregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance 
)
text clustered_variance_logregr ( )
text clustered_variance_logregr ( text  msg)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance,
boolean  verbose 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category,
text  grouping_col 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category,
text  grouping_col,
integer  max_iter 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category,
text  grouping_col,
integer  max_iter,
text  optimizer 
)
void clustered_variance_mlogregr ( text  tbl_data,
text  tbl_output,
text  depvar,
text  indvar,
text  clustervar,
integer  ref_category,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance 
)
text clustered_variance_mlogregr ( )
text clustered_variance_mlogregr ( text  msg)