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