On 4/15/22 15:18, David G. Johnston 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
