Re: psql \df choose functions by their arguments - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: psql \df choose functions by their arguments
Date
Msg-id CAKAnmmLTML5RJ3bvXjwY8Jk+fcQMB4-c1N_3axMcB+AytXQ0GQ@mail.gmail.com
Whole thread Raw
In response to Re: psql \df choose functions by their arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql \df choose functions by their arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I like the wildcard aspect, but I have a few issues with the patch:

* It doesn't respect some common abbreviations that work elsewhere (e.g. CREATE FUNCTION). So while "int4" works, "int" does not. Nor does "float", which thus requires the mandatory-double-quoted "double precision"

* Adding commas to the args, as returned by psql itself via \df, provides no matches.

* There seems to be no way (?) to limit the functions returned if they share a common root. The previous incantation allowed you to pull out foo(int) from foo(int, bigint). This was a big motivation for writing this patch.

* SQL error on \df foo a..b as well as one on \df foo (bigint bigint)

Cheers,
Greg

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: multi-install PostgresNode fails with older postgres versions
Next
From: Mark Dilger
Date:
Subject: Re: multi-install PostgresNode fails with older postgres versions