Re: Argument variables for select

On Mon, 28 Aug 2000, Yury Don wrote:

> Andreas Tille wrote:
> > 
> > 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' ;
> > 
> AFAIK it's impossible with plpgsql, but it's possible in pltcl.
Hmmm, I wonder how many languages I will learn while dealing with
PostgreSQL.  What about performance of pltcl compared to C.
I wonder if I just do all my work using C-functions, because I
know C very well and don't want to reach the next limit which
I will possibly face when using pltcl.

I would really like to write all my functions in SQL or PLPGSQL.
If this is really impossible (I just wonder if the construct above
could really not be implemented???), I would prefer C over other
languages, if there are no real drawbacks.

Kind regards
        Andreas.