I have a function with 3 parameters (select clause, where clause and order by clause (last two are optionally clauses). This clauses apply to a given table. For example, the table table1
and the function table1_rwc (read by where clause).
Given, let's say, the followings values select_clause = '*', where_clause 'id = 1' and the order_by clause = 'id', it will be generate the result set of the following query:
select * from Table1 where id = 1 order by id
I know I must use execute and prepare syntax, but I don't know how to create the function.
Can you help me, please.