is it possible to input parameters or use dynamic parameters in a function to get data with postgre?

[Gusta_ken]

Hi !

I'm trying to insert dynamic parameters into a function to get selected data from postgresql, I have the server and the Database, I just want to know if is possible to make somthing like this in the advanced options for SQL statement :

SELECT * FROM function(&variable1, &variable2, &variable3)

and  then it returns a table with my conditions.

is it possible? thanks!

[TeigeGao]

Hi @Gusta_ken ,

Could you please tell us what's problem did you meet when you are using the SQL Query? Generally, it should let you using the function with parameter.

Best Regards,

Teige