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
numCount(*) 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.