Re: [SQL] Argument variables for select

2000-08-28 Thread Yury Don
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; >

[SQL] Argument variables for select

2000-08-28 Thread Andreas Tille
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 someo