larapollehn · November 30, 2020 19:53
diff --git a/SQL Function (postgres) b/SQL Function (postgres)
 Simple exmple of a SQL Function for postgres. The function increments a given int by 1.

 CREATE FUNCTION increment (age int)
 RETURNS int 
 LANGUAGE plpgsql
 AS $$
 declare
  incremented_age int;
  BEGIN  
    incremented_age = age +1;
    RETURN incremented_age;
  END;
  $$;
	Simple exmple of a SQL Function for postgres. The function increments a given int by 1.

	CREATE FUNCTION increment (age int)
	RETURNS int
	LANGUAGE plpgsql
	AS $$
	declare
	incremented_age int;
	BEGIN
	incremented_age = age +1;
	RETURN incremented_age;
	END;
	$$;
No results found