dinamic sql

["Manso Gomez, Ramon" <rmgomez(at)indra(dot)es>]

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.