Creating Postgres Procedure 2

dinmil's profile image dinmil posted 8 years ago in General Permalink

I think that when you create postgres procedure via heidi program produce incorrect create statement


PRODUCED CODE:


CREATE FUNCTION "Test2"()
RETURNS BIGINT
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY INVOKER
COMMENT E''
BEGIN
  return 1
END



**************************************
CORRECT CODE:
**************************************

CREATE OR REPLACE FUNCTION public.fnctest (
)
RETURNS BIGINT AS
$body$
DECLARE
  variable_name integer;
BEGIN

  return 1;
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;

Please login to leave a reply, or register at first.