Re: Argument variables for select

Andreas Tille wrote:
> 
> 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.

AFAIK it's impossible with plpgsql, but it's possible in pltcl.

-- 
Sincerely yours,
Yury