pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (7+ messages)  latest in thread

Message-ID: <4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au>
Permalink:  ../4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au/
Also on:    postgresql.org/message-id/4.3.2.7.0.20000829232708.00b18828@mail.e-magine.com.au

 · 

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: 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