Re: function defined (or not), more worries on version 10->14 upgrade

On 4/15/22 15:18, David G. Johnston wrote:
> On Fri, Apr 15, 2022 at 2:04 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
> but have not found a combination of name/args for
> genome_threshold_mono(text,text,double precision)
>
>
> Per the fine documentation:
>
> \df[anptwS+] [ pattern [ arg_pattern ... ] ]
>
> So the correct formulation is:
>
> \df genome_threshold_mono text text 'double precision'
>
> You need to quote the fourth argument to protect the embedded space as
> a character and not an argument separator.
>
> David J.
>
Wow.  An old bad habit of using parens, I guess?

Do you consider this correct behaviour?

barnard=# \df public.genome_threshold_mono text,text
List of functions
 Schema |         Name          | Result data type
|                  Argument data types | Type
--------+-----------------------+------------------+--------------------------------------------------------+------
 public | genome_threshold_mono | uuid             | pbs_name text,
genome_name text                        | func
 public | genome_threshold_mono | uuid             | pbs_name text,
genome_name text, conf double precision | func
(2 rows)

i.e, is it automatically wildcarded?

And then, I dare say, this is just plain inconsistent, vis parens

barnard=# \sf public.genome_threshold_mono text,text
ERROR:  invalid name syntax
barnard=# \sf+ public.genome_threshold_mono text,text
ERROR:  invalid name syntax
barnard=# \sf+ public.genome_threshold_mono(text,text)
        CREATE OR REPLACE FUNCTION
public.genome_threshold_mono(pbs_name text, genome_name text)
         RETURNS uuid
         LANGUAGE plpgsql
1       AS $function$
2       declare
3         tid uuid;
4       begin
5         select genome_threshold_mono(pbs_name, genome_name, 1.96)
into tid;
6         return tid;
7       end;
8       $function$

But I'm taking it all as not an upgrade problem, getting back to work
Thanks to all,
rjs