Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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";
Add Comment
Please, Sign In to add comment