subject:"If there are more than two functions in different schemas, the functions have the same name and same arguments, \\df\[\+\] only display the function that schema first appeared in the search_path."

Re: If there are more than two functions in different schemas, the functions have the same name and same arguments, \df[+] only display the function that schema first appeared in the search_path.

2023-01-15 Thread David G. Johnston

On Sunday, January 15, 2023, 金 wrote: > > postgres=# \df fun1 > > List of functions > > Schema | Name | Result data type |Argument data types > | Type > > +--+--+- >

If there are more than two functions in different schemas, the functions have the same name and same arguments, \df[+] only display the function that schema first appeared in the search_path.

2023-01-15 Thread 金

Hi, I find if there are more than one functions in different schemas, and the functions have the same name and the same arguments, \df[+] only display the function that schema earlier appeared in the search_path. And SELECT pg_function_is_visible(funoid) returns f. Because in