Re: [GENERAL] Stored Procedures - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: [GENERAL] Stored Procedures
Date
Msg-id Pine.BSI.3.91.991105113706.13526B-100000@access1.lan2wan.com
Whole thread Raw
In response to Re: [GENERAL] Stored Procedures  ("Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>)
List pgsql-general
On Fri, 5 Nov 1999, Moray McConnachie wrote:

> > Yes, quite extensively, and far beyond what SQL 7 offers.  You may
> want
> > to take a look at the programmer's manual for the documentation.
>
> I thought we had rather a long debate recently about whether and if
> Postgres did/should support stored procedures, and the point was that
> it doesn't at the moment?
>
> PL/PgSQL functions are not at all the same thing, although they are
> obviously very useful.

What's the difference between the two, then?  What does a stored procedure
do that a function doesn't?  The PostgreSQL 'CREATE FUNCTION', as it is
described in the documentation, is very similar to the not yet
standardized stored module facility in SQL.

Brett W. McCoy
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Commitment, n.:
    Commitment can be illustrated by a breakfast of ham and eggs.
The chicken was involved, the pig was committed.


pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] indexed regex select optimisation missing?
Next
From: "Tsuchiya, Mitsy"
Date:
Subject: \dt doesn't work!