Re: User functions not displayed by \df

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: User functions not displayed by \df
Date: 2002-10-29 22:31:02
Message-ID: 24221.1035930662@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz> writes:
> Okay, me again. I was readin the psql source and noticed that (df)
> describeFunction explicitly excludes return type 0 which just happens to
> be opaque. I did a select on pg_proc and the functions that had the
> return type 0 happened to be returns OPAQUE.

> Does anybody know why this would be the case?

I believe the original idea was to avoid cluttering the display with
datatype I/O functions. In 7.3 we've narrowed the scope of this check
so that only functions taking/returning type "cstring" are suppressed.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message am 2002-10-29 22:31:09 Re: substitute variable in sql?
Previous Message Tom Lane 2002-10-29 22:18:54 Re: psql hanging