deeejay

psql - Create prepared statement with a function

Dec 17th, 2015
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION fnc_query()
  2.   RETURNS void AS
  3. $BODY$
  4. begin
  5. PREPARE ps_some_query AS
  6.  SELECT * FROM encounter;
  7.  EXECUTE ps_some_query;
  8. end;
  9. $BODY$
  10.   LANGUAGE plpgsql VOLATILE
  11.   COST 100;
  12. ALTER FUNCTION fnc_query()
  13.   OWNER TO "some_user";
Add Comment
Please, Sign In to add comment