bingo/postgres/sql/common/bingo_pg.sql.in

CREATE OR REPLACE FUNCTION getstructurescount(text) RETURNS int AS $$
begin
 return BINGO_SCHEMANAME._get_structures_count($1::regclass::oid);
end;
$$ LANGUAGE 'plpgsql';

CREATE OR REPLACE FUNCTION getblockcount(text) RETURNS int AS $$
begin
 return BINGO_SCHEMANAME._get_block_count($1::regclass::oid);
end;
$$ LANGUAGE 'plpgsql';

CREATE OR REPLACE FUNCTION precachedatabase(text, text) RETURNS text AS $$
begin
 return BINGO_SCHEMANAME._precache_database($1::regclass::oid, $2);
end;
$$ LANGUAGE 'plpgsql';

CREATE OR REPLACE FUNCTION _internal_func_011(integer, text, text) RETURNS void AS $$
BEGIN 
IF NOT BINGO_SCHEMANAME._internal_func_check($1) 
THEN RETURN;
END IF;
INSERT INTO pg_depend (classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype) 
VALUES (
'pg_class'::regclass::oid, $2::regclass::oid, 0, 
'pg_class'::regclass::oid, $3::regclass::oid, 0, 'i');
end;
$$ LANGUAGE 'plpgsql' SECURITY DEFINER;

CREATE OR REPLACE FUNCTION _internal_func_012(integer, text) RETURNS void AS $$
BEGIN 
IF NOT BINGO_SCHEMANAME._internal_func_check($1) 
THEN RETURN;
END IF;
DELETE FROM pg_depend WHERE objid=$2::regclass::oid;
end;
$$ LANGUAGE 'plpgsql' SECURITY DEFINER;