pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Webb Sprague <wsprague100@yahoo.com>
To: Andreas Tille <tillea@rki.de>
Cc: PostgreSQL SQL <pgsql-sql@hub.org>
Subject: Re: Re: Argument variables for select
Date: Tue, 29 Aug 2000 08:36:10 -0700 (PDT)
Message-ID: <20000829153610.29983.qmail@web803.mail.yahoo.com> (raw)

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/



view thread (7+ messages)

Message-ID: <20000829153610.29983.qmail@web803.mail.yahoo.com>
Permalink:  ../20000829153610.29983.qmail@web803.mail.yahoo.com/
Also on:    postgresql.org/message-id/20000829153610.29983.qmail@web803.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: wsprague100@yahoo.com, tillea@rki.de, pgsql-sql@hub.org
  Subject: Re: Argument variables for select
  In-Reply-To: <20000829153610.29983.qmail@web803.mail.yahoo.com>
  References: <20000829153610.29983.qmail@web803.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox