On 4/15/22 9:53 AM, Rob Sargent wrote:
The function in question is working but I'm having trouble getting at
it's current definition and the possibility that there are more v10->v14
issues in this database. The last ERROR: below seems to me "a system
thing"(tm)
barnard=# \df genome_threshold_mono
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)
barnard=# \df genome_threshold_mono(pbs_name text, genome_name text,
conf double precision);
ERROR: invalid regular expression: parentheses () not balanced
Don't use the column names just the data types:
\df genome_threshold_mono(text, text, double precision);
The supplied arguments to the function in question are obviously bogus,
but the reaction is correct, including call to nested functions.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
