| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Daniel Verite <daniel(at)manitou-mail(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] SQL procedures |
| Date: | 2017-11-15 08:56:18 |
| Message-ID: | 1510736178.2424.10.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> It would seem to be implied by the SQLStandard that Functions and
> Procedures occupy the same namespace, since they are both Routines.
>
> I can't see any benefit from having foo() function AND foo() procedure
> at same time. It would certainly confuse most people that come from
> programming languages without that distinction, but maybe someone
> knows some Oracle-foo that I don't?
The question already has been decided on the (better) basis of
the SQL standard, but for what it is worth:
Oracle has functions and procedures in the same name space.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2017-11-15 08:58:54 | Re: Transform for pl/perl |
| Previous Message | Michael Paquier | 2017-11-15 08:39:27 | Re: [HACKERS] Assertion failure when the non-exclusive pg_stop_backup aborted. |