Thread

Re: Re: Argument variables for select

Webb Sprague <wsprague100@yahoo.com> — 2000-08-29T15:36:10Z

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 <tillea@rki.de> 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/