| From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
|---|---|
| To: | Moray McConnachie <moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk> |
| Cc: | Jeff MacDonald <jeff(at)hub(dot)org>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Stored Procedures |
| Date: | 1999-11-05 16:42:23 |
| Message-ID: | Pine.BSI.3.91.991105113706.13526B-100000@access1.lan2wan.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-11-05 16:46:36 | Re: [HACKERS] Re: [GENERAL] indexed regex select optimisation missing? |
| Previous Message | Bruce Momjian | 1999-11-05 16:37:02 | Re: [GENERAL] indexed regex select optimisation missing? |