133 lines
9.3 KiB
SQL
133 lines
9.3 KiB
SQL
DROP OPERATOR IF EXISTS + ( pip_eqn , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS + ( integer , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS + ( pip_eqn , integer ) CASCADE;
|
|
DROP OPERATOR IF EXISTS + ( double precision, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS + ( pip_eqn , double precision ) CASCADE;
|
|
DROP OPERATOR IF EXISTS * ( pip_eqn , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS * ( integer , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS * ( pip_eqn , integer ) CASCADE;
|
|
DROP OPERATOR IF EXISTS * ( double precision, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS * ( pip_eqn , double precision ) CASCADE;
|
|
DROP OPERATOR IF EXISTS - ( pip_eqn , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS - ( integer , pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS - ( pip_eqn , integer ) CASCADE;
|
|
DROP OPERATOR IF EXISTS - ( double precision, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS - ( pip_eqn , double precision ) CASCADE;
|
|
DROP OPERATOR IF EXISTS | ( pip_world_presence, pip_world_presence ) CASCADE;
|
|
DROP OPERATOR IF EXISTS > ( pip_eqn, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS > ( double precision, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS > ( pip_eqn, double precision ) CASCADE;
|
|
DROP OPERATOR IF EXISTS < ( pip_eqn, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS < ( pip_eqn, double precision ) CASCADE;
|
|
DROP OPERATOR IF EXISTS < ( double precision, pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS << ( NONE,pip_eqn ) CASCADE;
|
|
DROP OPERATOR IF EXISTS @ ( pip_expectation, record ) CASCADE;
|
|
DROP OPERATOR IF EXISTS >> ( pip_expectation ,NONE) CASCADE;
|
|
DROP AGGREGATE IF EXISTS conf_naive (record,pip_sample_set) CASCADE;
|
|
DROP AGGREGATE IF EXISTS conf_sample (record,pip_sample_set) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_max_hist (pip_eqn, record) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_max (pip_eqn, record) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_max (pip_value_bundle) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_sum_hist (pip_eqn, record) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_sum (pip_eqn, record) CASCADE;
|
|
DROP AGGREGATE IF EXISTS expectation_sum (pip_eqn, record, integer) CASCADE;
|
|
DROP AGGREGATE IF EXISTS max(double precision, record) CASCADE;
|
|
DROP AGGREGATE IF EXISTS pip_world_presence_union (pip_world_presence) CASCADE;
|
|
DROP AGGREGATE IF EXISTS sum(pip_eqn) CASCADE;
|
|
DROP AGGREGATE IF EXISTS sum (pip_value_bundle) CASCADE;
|
|
DROP AGGREGATE IF EXISTS sum (pip_value_bundle,pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS conf_naive_g (pip_world_presence,record,pip_sample_set) CASCADE;
|
|
DROP FUNCTION IF EXISTS conf_one (record) CASCADE;
|
|
DROP FUNCTION IF EXISTS conf_sample_g (pip_conf_tally,record,pip_sample_set) CASCADE;
|
|
DROP FUNCTION IF EXISTS create_variable(cstring, integer, cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS create_variable(cstring, integer, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS create_variable(varchar, anyelement) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_max_f_one(pip_atomset) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_max_g_one(pip_atomset, double precision, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_max_g(pip_sample_set, pip_eqn, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation(pip_eqn, record, integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation(pip_eqn, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_sum_g_one(double precision, pip_eqn, record, integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_sum_g_one(double precision, pip_eqn, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS expectation_sum_g(pip_sample_set, pip_eqn, record) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_gt(double precision,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_gt(pip_eqn,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_gt(pip_eqn,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_lt(double precision,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_lt(pip_eqn,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_create_lt(pip_eqn,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atom_out(pip_atom) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atomset_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_atomset_out(pip_atomset) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_cdf_enabled(integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_conf_tally_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_conf_tally_out(pip_conf_tally) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_conf_tally_result(pip_conf_tally) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_compile_sum(pip_eqn,pip_eqn,record) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_compile_sum(pip_eqn,pip_eqn ) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_mul(double precision,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_mul(integer,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_mul(pip_eqn,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_mul(pip_eqn,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_mul(pip_eqn,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_neg(pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_out(pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sub(double precision,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sub(integer,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sub(pip_eqn,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sub(pip_eqn,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sub(pip_eqn,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sum(double precision,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sum(integer,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sum(pip_eqn,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sum(pip_eqn,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_eqn_sum(pip_eqn,pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_expectation_expect(pip_expectation) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_expectation_fix(pip_expectation,record) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_expectation_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_expectation_make(pip_eqn) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_expectation_out(pip_expectation) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_sample_set_expect(pip_sample_set) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_sample_set_explode(pip_sample_set) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_sample_set_generate(record,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_sample_set_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_sample_set_out(pip_sample_set) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_add(pip_value_bundle,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_add(pip_value_bundle,pip_value_bundle,pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_add(pip_value_bundle,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_cmp(pip_world_presence,double precision,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_cmp(pip_world_presence,integer,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_cmp(pip_world_presence,pip_value_bundle,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_cmp(pip_world_presence,pip_value_bundle,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_cmp(pip_world_presence,pip_value_bundle,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_create(pip_eqn,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_expect(pip_value_bundle,integer,integer,pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_expect(pip_value_bundle,integer,integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_expect(pip_value_bundle,pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_expect(pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_max(pip_value_bundle,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_mul(pip_value_bundle,double precision) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_mul(pip_value_bundle,pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_value_bundle_out(pip_value_bundle) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_var_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_var_out(pip_var) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_count(pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_create(integer) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_in(cstring) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_join(pip_world_presence,pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_out(pip_world_presence) CASCADE;
|
|
DROP FUNCTION IF EXISTS pip_world_presence_union(pip_world_presence,pip_world_presence) CASCADE;
|
|
DROP TYPE IF EXISTS pip_var CASCADE;
|
|
DROP TYPE IF EXISTS pip_atom CASCADE;
|
|
DROP TYPE IF EXISTS pip_sample_set CASCADE;
|
|
DROP TYPE IF EXISTS pip_conf_tally CASCADE;
|
|
DROP TYPE IF EXISTS pip_value_bundle CASCADE;
|
|
DROP TYPE IF EXISTS pip_world_presence CASCADE;
|
|
DROP TYPE IF EXISTS pip_eqn CASCADE;
|
|
DROP TYPE IF EXISTS pip_expectation CASCADE;
|
|
DROP TYPE IF EXISTS pip_atomset CASCADE;
|
|
DROP SEQUENCE IF EXISTS pip_var_id CASCADE;
|