Stored Procedure: PostgreSQL DB
Objective
  • creating stored procedure using pgAdminIII: pgAdmin3.exe
  •  
 

 

Script

-- Function: cfcal(numeric)

-- DROP FUNCTION cfcal(numeric);

CREATE OR REPLACE FUNCTION cfcal(i numeric)
RETURNS numeric AS
$BODY$
DECLARE
temp1 numeric ;
BEGIN
/*select cfcal(i+40) INTO temp1;*/
RETURN (i * 9/5) + 32 ;

END;

$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION cfcal(numeric)
OWNER TO postgres;
 
Now open a sql worksheet
 Script: select round (cfcal(19.25), 2);