20250214_2.sql 463 B

123456789101112131415161718192021222324
  1. -- FUNCTION: public.fnHeaderGetPressure(numeric)
  2. -- DROP FUNCTION IF EXISTS public."fnHeaderGetPressure"(numeric);
  3. CREATE OR REPLACE FUNCTION public."fnHeaderGetPressure"(
  4. pressure numeric)
  5. RETURNS numeric
  6. LANGUAGE 'plpgsql'
  7. COST 100
  8. VOLATILE PARALLEL UNSAFE
  9. AS $BODY$
  10. declare
  11. var_result numeric;
  12. begin
  13. var_result := 1 + pressure;
  14. return var_result;
  15. end;
  16. $BODY$;
  17. ALTER FUNCTION public."fnHeaderGetPressure"(numeric)
  18. OWNER TO admin;