Created
August 2, 2017 19:05
-
-
Save sanjaypojo/e10054041d9ac45316731915b78701b1 to your computer and use it in GitHub Desktop.
Postgres Stored Function Template (plpgsql)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP FUNCTION IF EXISTS my_stored_function(integer, varchar, varchar ); | |
| CREATE OR REPLACE FUNCTION table_space.my_stored_function (var1 integer, var2 varchar, var3 varchar) | |
| RETURNS TABLE (col1 integer, col2 integer, col3 varchar, col4 varchar) | |
| AS | |
| $BODY$ | |
| DECLARE | |
| local_variable integer; | |
| BEGIN | |
| SELECT average(age) | |
| INTO local_variable | |
| FROM some_table | |
| WHERE country = 'USA'; | |
| RETURN QUERY | |
| SELECT name, income | |
| FROM some_other_table | |
| WHERE age < local_variable; | |
| END; | |
| $BODY$ | |
| LANGUAGE plpgsql VOLATILE; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment