Hi
I need to write a Postgres function which executes a cursor. Query of
this cursor however is created on the basis of parameters passed by
user.
if(user_Input = 'a')
l_query := l_query||a_from_clause ||'where ename in '||user_Input
else
if(user_Input = 'b')
l_query := l_query||b_from_clause||'where ename in '||user_Input
OPEN csr FOR l_query;
How do we do it is postgres. My problem I know how to pass parameters
like "ename=parameter", but If the SQL sentence is ename in
(parameters). It does not work.
Thanx in Advance.