This topic is locked

How to pass parameters to a custom PostgreSQL function before executing the query?

5/30/2017 1:20:12 PM
PHPRunner General questions
johnnlenon author

Hello, I have the following scenario:
1 - I created a function in PostgreSQL that receives two dates, beginning and end in format "date", for example: function (date, date);
2- This function returns columns that should be displayed to the user.
Is it possible for the user to type the two dates in the frontend interface before executing the query, and with these entries the function receive the parameters and thus return the desired query?
If possible in which event to place?