| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] SQL procedures |
| Date: | 2017-12-01 16:12:13 |
| Message-ID: | CANP8+j+nyynsZ2Bm3N3ss-izHdM-cF-pZmqrNyUofEQ9i79z2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2 December 2017 at 01:31, Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> On 11/30/17 15:50, Thomas Munro wrote:
>> postgres=# \df
>> List of functions
>> Schema | Name | Result data type | Argument data types | Type
>> --------+------+------------------+---------------------+------
>> public | bar | integer | i integer | func
>> public | foo | | i integer | proc
>> (2 rows)
>>
>> Should this now be called a "List of routines"?
>
> Maybe, but I hesitate to go around and change all mentions of "function"
> like that. That might just confuse people.
Agreed
\dfn shows functions only
so we might want to consider having
\df say "List of functions and procedures"
\dfn say "List of functions"
and a new option to list procedures only
\dfp say "List of procedures"
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bossart, Nathan | 2017-12-01 16:29:06 | Re: [HACKERS] Additional logging for VACUUM and ANALYZE |
| Previous Message | Robert Haas | 2017-12-01 16:11:04 | Re: [HACKERS] Constraint exclusion for partitioned tables |