From: Keith Wong <keith@e-magine.com.au>
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 23:33:06 +1000
Message-ID: <4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au> (raw)
In-Reply-To: <Pine.LNX.4.21.0008291403150.7758-100000@wr-linux02.rki.de>
References: <39AA2F1C.2CCE9860@vpcit.ru>
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 procedure features? I'm not sure what your
application is exactly but there are ways
to work around the features that are missing.
Good luck with convincing your boss :)
Keith.
At 02:28 PM 29/08/2000 +0200, Andreas Tille 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.
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: keith@e-magine.com.au, tillea@rki.de, pgsql-sql@hub.org
Subject: Re: Argument variables for select
In-Reply-To: <4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au>
References: <39AA2F1C.2CCE9860@vpcit.ru> <4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au>
* 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