Not all functions in schema pg_catalog are "visible" - Mailing list pgsql-general

From Thomas Kellerer
Subject Not all functions in schema pg_catalog are "visible"
Date
Msg-id hmk6jh$8t2$1@dough.gmane.org
Whole thread Raw
Responses Re: Not all functions in schema pg_catalog are "visible"
List pgsql-general
Hi,

I just noticed that that there are functions defined (such as pg_catalog.time(timestamp) that can only be called when
prefixedwith pg_catalog. However other functions (that are at first glance defined identically to time()) can be called
withoutprefixing them with pg_catalog. 

My understanding is that time(timestamp) is there to support the various CAST ( .. ) expressions, but why isn't it
exposedas a "regular" function as well (as it seems to work just fine when being called directly) 

So, just out of curiosity: how could I tell by looking at pg_proc (or other system tables) which of those functions is
"public"and which is not? 

Regards
Thomas

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: FSM and VM file
Next
From: Tom Lane
Date:
Subject: Re: disable triggers isolated to transaction only?