Re: Internal functions(?)

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Devrim GUNDUZ wrote:
>> Is there a full list of these functions on web?

The 7.2 documentation lists more of them than it used to, eg
http://developer.postgresql.org/docs/postgres/functions-misc.html

I'm sure we are still missing some, however, since a lot of people
have been pretty lax about documenting :-(

Anyone care to go through pg_proc and the special cases in the parser
to see what's still undocumented?

> In psql, \df. I see version() but not current_date. I think it is
> mapped internally as "select date('now');".

I believe that \df suppresses functions that it deems uninteresting,
so I wouldn't entirely trust its output for this purpose, even aside
from the problem of parser mappings for some functions.

regards, tom lane