Re: psql \df choose functions by their arguments

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: psql \df choose functions by their arguments
Дата
Msg-id CAKAnmmLTML5RJ3bvXjwY8Jk+fcQMB4-c1N_3axMcB+AytXQ0GQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \df choose functions by their arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: psql \df choose functions by their arguments
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: multi-install PostgresNode fails with older postgres versions
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: multi-install PostgresNode fails with older postgres versions