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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: HEAD \df doesn't show functions with no arguments
Date: 2005-03-31 06:06:39
Message-ID: 2589.1112249199@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-03-31 06:56:52 Re: [HACKERS] contrib/pg_buffercache
Previous Message Michael Fuhr 2005-03-31 05:49:08 HEAD \df doesn't show functions with no arguments

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2005-03-31 06:56:52 Re: [HACKERS] contrib/pg_buffercache
Previous Message Michael Fuhr 2005-03-31 05:49:08 HEAD \df doesn't show functions with no arguments