Good day all,

I am new to PostgreSQL and I am trying to call functions from a function. I have accomplished that without problems. The task now is to submit parameters to the main function and then use these submitted parameters to the other functions that are being called from the main parameter.

An example of what I have done so far is :

main_function (integer, integer, text)
SELECT subfunction($1,$3)
SELECT subfunction2($2,$3)

However it is not working.
Can someone give me a hint on this?

Thank you.