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 be an Oracle or MS-SQL DBA in a week or so either. 2. Postgres is FREE. NO MONEY. 3. Postgres integrates very easily into a Unix environment. 4. Proprietary software is going the way of the Do-Do. Well that's four. At my job, we are building a database in Postgres to replace an MS-SQL thing. My version takes 12 hours to upload a months worth of data. You think that is bad--the SQL Server took 15 DAYS. Good luck, and sorry for the rant. W --- Andreas Tille <[EMAIL PROTECTED]> wrote: > 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' ; > > > > > > 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 ) > > > > > AFAIK it's impossible with plpgsql, but it's > possible in pltcl. > > It is really hard to believe that I'm in so very > deep trouble with > PostgreSQL. It seems to me that stored procedures > are far from beeing > as usefull as I learned them to know in MS SQL > server. Once I try > to follow one hint I'm standing in frot of the next > even harder problem. > > > web=# create function testfunc( ) > web-# returns int > web-# As ' > web'# spi_exec "SELECT count(*) AS $num FROM > testtable" > web'# > web'# return $num ; > web'# End; ' > web-# language 'pltcl' ; > ERROR: Unrecognized language specified in a CREATE > FUNCTION: 'pltcl'. Recognized languages are sql, C, > internal and the created procedural languages. > > > I have installed the pgtcl package of my Debian > distribution, so I guess > it should be available. Once more the question: Is > it really necessary to > use a further interpreter instead of sticking with > SQL commands to use > the original problem. > > I have to admit that my boss wonders why I'm > switching from a working > solution (MS SQL) to so much trouble :-(. I really > hope to convince him > to OpenSource but it's much harder than I expected. > > Kind regards > > Andreas. > __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
