profile.sql_in File Reference

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

Date

January 2011

See also

For a brief introduction to "profiles", see the module description Profile. Cf. also the module Cardinality Estimators.

Function Documentation

anyarray array_collapse

(

anyarray

input

)

Parameters

input

Mult-dim array

Returns

One dimensional anyarray

set<profile_result> profile

(

text

input_table

)

Parameters

input_table

table name to analyze

Returns

Set of PROFILE_RESULT type

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

Parameters

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

Returns

Set of PROFILE_RESULT type