Thomas Kellerer wrote: > Hi, > > I just noticed that that there are functions defined (such as > pg_catalog.time(timestamp) that can only be called when prefixed with > pg_catalog. However other functions (that are at first glance defined > identically to time()) can be called without prefixing them with pg_catalog.
I think it's not that they are visible but rather that their names are keywords. So you could also call them by quoting them, e.g. "time"(timestamp). IIRC there's a view listing all keywords you can use to figure this out. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
