Re: [SQL] Re: Argument variables for select

2000-08-29 Thread Webb Sprague
I think you have to run "createlang pltcl db-foo" from the command line. As for your boss, here are three things I can think of off the top of my head: 1. All new products take some time to learn. If you can't use Postgres perfectly in a week or so, remember that you probably can't learn to b

Re: [SQL] Re: Argument variables for select

2000-08-29 Thread hlefebvre
Keith Wong wrote: > > Hi Andreas, > > I've worked with MS SQL stored procedures before and they are quite > powerful. Its a shame postgres doesn't have the same > level of features as offered by MS SQL, MS SQL is based on source code of Sybase v5. MS bought this source code to sybase. Sybase

Re: [SQL] Re: Argument variables for select

2000-08-29 Thread Keith Wong
Hi Andreas, I've worked with MS SQL stored procedures before and they are quite powerful. Its a shame postgres doesn't have the same level of features as offered by MS SQL, but apart from this area it is still a very good database. Perhaps in the coming versions we will see more stored procedur

[SQL] Re: Argument variables for select

2000-08-29 Thread Andreas Tille
On Mon, 28 Aug 2000, Yury Don 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' ; > > > >

[SQL] Re: Argument variables for select

2000-08-28 Thread Andreas Tille
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 ; > >' l