Re: Internal functions(?) - Mailing list pgsql-general

From Tom Lane
Subject Re: Internal functions(?)
Date
Msg-id 28738.1011734794@sss.pgh.pa.us
Whole thread Raw
In response to Re: Internal functions(?)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: frustration with database size
Next
From: Nate Haggard
Date:
Subject: pltclu createlang for pgMail