| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | Shay Rojansky <roji(at)roji(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>, Daniel Verite <daniel(at)manitou-mail(dot)org>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Stored procedures and out parameters |
| Date: | 2018-08-22 16:49:40 |
| Message-ID: | CAKFQuwamh9RzxsCyDZHeupQX3adWaYTePQ0D0_dXZygx7vFmRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Aug 22, 2018 at 9:39 AM, Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> On 16/08/2018 19:54, Shay Rojansky wrote:
> > I don't think there's anything really Microsoft-specific about any of
> > this (except maybe in the history) - just like JDBC and psycopg, there's
> > simply a single standard way in the database API for invoking
> > server-side things, and not two ways.
>
> Have you looked what those standard interfaces do in other SQL
> implementations (e.g., Oracle, DB2, Derby, MySQL)? AFAICT in no case
> does it involve allowing functions to be called as procedures or vice
> versa.
That is all well and good except PostgreSQL took its sweet time
implementing procedures and so effectively encouraged its community to
dual-purpose functions. Now the community is simply asking core to
recognize that history and dual-purpose the "CALL" command.
What others have done doesn't change the situation that has arisen for
PostgreSQL due to its implementation history.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-08-22 16:51:55 | Re: Query is over 2x slower with jit=on |
| Previous Message | Peter Eisentraut | 2018-08-22 16:39:38 | Re: Stored procedures and out parameters |