Robert Haas wrote: > > I am not thrilled about inventing a new column for this, but how about > > a display like so: > > > > regression=# \df nth_value > > List of functions > > Schema | Name | Result data type | Argument data types > > ------------+-----------+------------------+--------------------------------- > > pg_catalog | nth_value | anyelement | anyelement, integer OVER window > > > > or some other addition that only shows up when needed. > > I think this whole idea is a bad one. In the current release, you can do > > DROP FUNCTION Name ( Argument data types ) > > ...and it will work. Maybe you will say that no one is doing this via > a script (which I wouldn't bet on, but it's possible) but I'm sure > people are doing it via cut and paste, because I have done exactly > this thing. Any of the various proposals for hacking up Argument data > types will make this no longer true, and somebody will get confused. > I think you should bite the bullet and add a "type" column (f for > regular function and w for window? could there be others in the > future?).
I assume this is still an open issue. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
