SQL function for single-pass table profiles. More...

Functions
set< profile_result >	profile (text input_table)
	Compute a simple "profile" of a table or view. More...

set< profile_result >	profile_full (text input_table, integer buckets)
	Compute a full "profile" of a table or view. More...

anyarray	array_collapse (anyarray input)
	Collapses n-dimensional Arrays to 1-dim Array, so they can be read in pl/python can read it. Otherwise we would get ERROR: cannot convert multidimensional array to Python list. More...

Detailed Description

See Also: For a brief introduction to "profiles", see the module description Profile. Cf. also the module Sketch-based Estimators.

Definition in file profile.sql_in.

Function Documentation

anyarray array_collapse ( anyarray input)

Parameters

input Mult-dim array

Definition at line 183 of file profile.sql_in.

set<profile_result> profile ( text input_table)

Parameters

input_table table name to analyze

Definition at line 146 of file profile.sql_in.

set<profile_result> profile_full	(	text	input_table,
		integer	buckets
	)

Parameters

input_table	table name to analyze
buckets	number of buckets for histogram functions

Definition at line 164 of file profile.sql_in.