How to call function inside procedure in PostgreSQL?
How to call function inside procedure in PostgreSQL?
2 answers
@gilbert
In PostgreSQL, you can call a function inside a procedure by using the following syntax:
1
|
SELECT function_name(parameter1, parameter2, ...); |
For example, if you have a function named "calculate_sum" that takes two integer parameters and returns their sum, you can call it inside a procedure like this:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
CREATE OR REPLACE PROCEDURE my_procedure() AS $$ BEGIN -- Declare a variable to hold the result of the function DECLARE result INTEGER; -- Call the function and store the result in the variable SELECT calculate_sum(10, 20) INTO result; -- Do something with the result, such as printing it to the console RAISE NOTICE 'The result is: %', result; END; $$ LANGUAGE plpgsql; |
You can then call the procedure using the following command:
1
|
CALL my_procedure(); |
This will execute the code inside the procedure, which will call the function and print the result to the console.
Note that you can also pass parameters to the procedure, which can then be used as input to the function. For example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
CREATE OR REPLACE PROCEDURE my_procedure(param1 INTEGER, param2 INTEGER) AS $$ BEGIN -- Declare a variable to hold the result of the function DECLARE result INTEGER; -- Call the function and store the result in the variable SELECT calculate_sum(param1, param2) INTO result; -- Do something with the result, such as printing it to the console RAISE NOTICE 'The result is: %', result; END; $$ LANGUAGE plpgsql; |
You can then call the procedure and pass the parameters like this:
1
|
CALL my_procedure(10, 20); |
This will execute the code inside the procedure, passing the values 10 and 20 as parameters to the function, and printing the result to the console.