Hello,

I want to use the following construct in a stored function:

Create Function VarSelect ( varchar, varchar )
   returns int
   As '
     Declare num int ;
     
     Begin
       Select Into num Count(*) From $1 Where $2 ;
       return num;
     End ;
   ' language 'plpgsql' ;

Could someone please explain who to type the exact syntax so that
I can ship the table to select from as $1 and the condition to select
what as $2?  Or do I have to concatenate a string with the whole
select statement and how to call this string?  In MS SQL server this
could be done with 
   Exec ( query )

Kind regards

          Andreas.

Reply via email to