I have a procedure which contain this piece of code
SELECT query INTO query FROM temp_table_test WHERE id = whateverId;
EXECUTE query;
My query variable will contain something like
CALL Someprocedure (withSomeParameters)
How can i make the parameter dynamic in the first proc as they can change time to time and i can't make them static in the variable ?
in t-SQL there is something with
sp_executesql
But as I'm very new to postgres I don't know where to start.