clustered_variance.sql_in File Reference

Functions
void	clustered_variance_linregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col)
	Compute the clustered errors. More...
void	clustered_variance_linregr (text source_table, text out_table, 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 source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer, float8 tolerance, boolean verbose_mode)
void	clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar)
void	clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col)
void	clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter)
void	clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer)
void	clustered_variance_logregr (text source_table, text out_table, 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 source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, text optimizer_params, boolean verbose_mode)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, text optimizer_params)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname)
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)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer, float8 tolerance, boolean verbose_mode)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer, float8 tolerance)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer)
void	clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter)

Function Documentation

__array_add()

float8 [] __array_add	(	float8 []	x,
		float8 []	y
	)

__array_sum()

aggregate float8 [] __array_sum

(

float8

[]

)

__clustered_err_lin_final()

__clustered_agg_result __clustered_err_lin_final

(

bytea8

state

)

__clustered_err_lin_merge()

bytea8 __clustered_err_lin_merge	(	bytea8	state1,
		bytea8	state2
	)

__clustered_err_lin_step()

aggregate __clustered_agg_result __clustered_err_lin_step	(	float8	,
		float8	[],
		float8	[]
	)

__clustered_err_lin_transition()

bytea8 __clustered_err_lin_transition	(	bytea8	state,
		float8	y,
		float8 []	x,
		float8 []	coef
	)

__clustered_err_log_final()

__clustered_agg_result __clustered_err_log_final

(

bytea8

state

)

__clustered_err_log_merge()

bytea8 __clustered_err_log_merge	(	bytea8	state1,
		bytea8	state2
	)

__clustered_err_log_step()

aggregate __clustered_agg_result __clustered_err_log_step	(	boolean	,
		float8	[],
		float8	[]
	)

__clustered_err_log_transition()

bytea8 __clustered_err_log_transition	(	bytea8	state,
		boolean	y,
		float8 []	x,
		float8 []	coef
	)

__clustered_err_mlog_final()

__clustered_agg_result __clustered_err_mlog_final

(

bytea8

state

)

__clustered_err_mlog_merge()

bytea8 __clustered_err_mlog_merge	(	bytea8	state1,
		bytea8	state2
	)

__clustered_err_mlog_step()

aggregate __clustered_agg_result __clustered_err_mlog_step	(	integer	,
		float8	[],
		float8	[],
		integer	,
		integer
	)

__clustered_err_mlog_transition()

bytea8 __clustered_err_mlog_transition	(	bytea8	state,
		integer	y,
		float8 []	x,
		float8 []	coef,
		integer	num_cat,
		integer	ref_cat
	)

__clustered_lin_compute_stats()

__clustered_lin_result __clustered_lin_compute_stats	(	float8 []	coef,
		float8 []	meatvec,
		float8 []	breadvec,
		integer	mcluster,
		integer	numrows
	)

__clustered_log_compute_stats()

__clustered_log_result __clustered_log_compute_stats	(	float8 []	coef,
		float8 []	meatvec,
		float8 []	breadvec,
		integer	mcluster,
		integer	numrows
	)

__clustered_mlog_compute_stats()

__clustered_mlog_result __clustered_mlog_compute_stats	(	float8 []	coef,
		float8 []	meatvec,
		float8 []	breadvec,
		integer	mcluster,
		integer	numrows
	)

clustered_variance_linregr() [1/4]

void clustered_variance_linregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col
	)

Parameters

source_table	Data table name
out_table	The result table
depvar	Dependent variable expression
indvar	Independent variable expression
clustervar	The expressions used to clustering
grouping_col	The names of grouping columns

clustered_variance_linregr() [2/4]

void clustered_variance_linregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar
	)

clustered_variance_linregr() [3/4]

text clustered_variance_linregr

(

)

clustered_variance_linregr() [4/4]

text clustered_variance_linregr

(

text

msg

)

clustered_variance_logregr() [1/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col,
		integer	max_iter,
		text	optimizer,
		float8	tolerance,
		boolean	verbose_mode
	)

clustered_variance_logregr() [2/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar
	)

clustered_variance_logregr() [3/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col
	)

clustered_variance_logregr() [4/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col,
		integer	max_iter
	)

clustered_variance_logregr() [5/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col,
		integer	max_iter,
		text	optimizer
	)

clustered_variance_logregr() [6/8]

void clustered_variance_logregr	(	text	source_table,
		text	out_table,
		text	depvar,
		text	indvar,
		text	clustervar,
		text	grouping_col,
		integer	max_iter,
		text	optimizer,
		float8	tolerance
	)

clustered_variance_logregr() [7/8]

text clustered_variance_logregr

(

)

clustered_variance_logregr() [8/8]

text clustered_variance_logregr

(

text

msg

)

clustered_variance_mlogregr() [1/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		text	optimizer_params,
		boolean	verbose_mode
	)

clustered_variance_mlogregr() [2/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		text	optimizer_params
	)

clustered_variance_mlogregr() [3/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols
	)

clustered_variance_mlogregr() [4/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category
	)

clustered_variance_mlogregr() [5/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname
	)

clustered_variance_mlogregr() [6/11]

text clustered_variance_mlogregr

(

)

clustered_variance_mlogregr() [7/11]

text clustered_variance_mlogregr

(

text

msg

)

clustered_variance_mlogregr() [8/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		integer	max_iter,
		varchar	optimizer,
		float8	tolerance,
		boolean	verbose_mode
	)

clustered_variance_mlogregr() [9/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		integer	max_iter,
		varchar	optimizer,
		float8	tolerance
	)

clustered_variance_mlogregr() [10/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		integer	max_iter,
		varchar	optimizer
	)

clustered_variance_mlogregr() [11/11]

void clustered_variance_mlogregr	(	text	source_table,
		text	out_table,
		text	dependent_varname,
		text	independent_varname,
		text	cluster_varname,
		integer	ref_category,
		text	grouping_cols,
		integer	max_iter
	)