Re: psql \df choose functions by their arguments
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Ian Lawrence Barwick <barwick@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-04-07T21:58:24Z
Lists: pgsql-hackers
Attachments
- v8-psql-df-pick-function-by-type.patch (text/x-diff) patch v8
I wrote: > Greg Sabino Mullane <htamfids@gmail.com> writes: >> * SQL error on \df foo a..b as well as one on \df foo (bigint bigint) > The first one seems to be a bug, will look. Argh, silly typo (and I'd failed to test the schema-qualified-name case). While I was thinking about use-cases for this, I realized that at least for me, being able to restrict \do operator searches by input type would be even more useful than is true for \df. Operator names tend to be overloaded even more heavily than functions. So here's a v8 that also fixes \do in the same spirit. (With respect to the other point: for \do it does seem to make sense to constrain the match to operators with exactly as many arguments as specified. I still say that's a bad idea for functions, though.) regards, tom lane
Commits
-
Allow psql's \df and \do commands to specify argument types.
- a3027e1e7f3d 14.0 landed