| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Not all functions in schema pg_catalog are "visible" |
| Date: | 2010-03-09 19:31:07 |
| Message-ID: | 20100309193106.GB3280@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Chobot | 2010-03-09 19:35:31 | Re: obsessive-compulsive vacuum behavior |
| Previous Message | Adrian Klaver | 2010-03-09 18:41:26 | Re: \copy command: how to define a tab character as the delimiter |