deeejay icon

psql - Create prepared statement with a function

deeejay | PRO | 12/17/15 04:23:34 PM UTC | 0 ⭐ | 208 👁️ | Never ⏰ | []
PostgreSQL |

250 B

|

None

|

0 👍

/

0 👎

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";

Comments