create or replace function process(int2) returns text as ' begin return ''I am in standard''; end; ' language 'plpgsql'; create or replace function add_one(int4) returns int4 as ' begin return $1 + 1; end; ' language 'plpgsql'; create or replace package nametest as function docheck() returns text as ' begin return process(changer(4)); end; ' language 'plpgsql' function changer(int4) returns int2 as ' begin return $1; end; ' language 'plpgsql' function process(int4) returns text as ' begin return ''I am in the package''; end; ' language 'plpgsql' function do_add(int4) returns int4 as ' begin return add_one($1); end; ' language 'plpgsql' function louella(int4) returns int4 as 'select add_one($1);' language 'sql' function lar(int4) returns int4 as 'select nametest.louella($1);' language 'sql' function inga(int4) returns int2 as 'select changer($1);' language 'sql';