Robert Haas <robertmhaas@gmail.com> writes:
> You seem to be assuming that conflicts between user-defined functions
> and system functions are a common problem against which users need
> protection. I have been using PostgreSQL for almost 10 years and am
> not sure that I've EVER had a problem with this.
Probably not, else it would be seared into your memory and you'd not be
in favor of making a change that increases the odds of repeating the
experience ;-)
> On the other hand, I want to look at and search my user-defined
> functions FREQUENTLY. I don't care about the system functions. If I
> type \df a*, it's not because I want to see all 6 versions of the
> absolute value function and 61 other functions, it's because I don't
> want to think hard enough to remember how I spelled the first word in
> one of my functions that I know starts with "a".
Well, maybe we do need to go with the \df \dfS \dfU approach.
But I'm still convinced that setting things up so that it's impossible
to search both classes of functions together is a seriously bad idea.
regards, tom lane