Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group