CREATE OR REPLACE FUNCTION fnc_query() RETURNS void AS $BODY$ begin PREPARE ps_some_query AS SELECT * FROM encounter; EXECUTE ps_some_query; end; $BODY$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION fnc_query() OWNER TO "some_user";