Re: HEAD \df doesn't show functions with no arguments

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: HEAD \df doesn't show functions with no arguments
Дата
Msg-id 2589.1112249199@sss.pgh.pa.us
обсуждение исходный текст
Ответ на HEAD \df doesn't show functions with no arguments  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: HEAD \df doesn't show functions with no arguments
Re: HEAD \df doesn't show functions with no arguments
Список pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> The problem appears to be that proargtypes[0] is now NULL instead
> of 0.  Here's a simplified version of the \df query:

>   SELECT proname
>   FROM pg_catalog.pg_proc p
>   WHERE p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype
>     AND p.proname ~ '^foo$';

We could fix it by changing <> to IS DISTINCT FROM ... but I've never
been very happy with the idea that \df tries to suppress I/O functions
anyway.  How do you feel about removing the cstring test altogether?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: HEAD \df doesn't show functions with no arguments
Следующее
От: shingav
Дата:
Сообщение: Understanding pg_xlog