Re: A table of magic constants

On 11/07/2015 20:07, Dane Foster wrote:

<snip>

> As a recent convert to the Church of Postgres I've been consuming vast

Welcome to the One True Faith! :-)

> amounts of information on PostgreSQL, and SESSION_USER is not the first
> nor only, what I'm calling magic constant, that I've seen. Off the top
> of my head, other examples that I've encountered are CURRENT_USER and
> CURRENT_TIMESTAMP.
>
> So my question is this, is there a reference table in the documentation
> that I haven't found yet that lists all magic constants and their
> meaning? And if not in the official documentation is it in the wiki?

session_user, current_timestamp and current_user are all functions, not
magic constants:

http://www.postgresql.org/docs/9.4/static/functions-datetime.html
http://www.postgresql.org/docs/9.4/static/functions-info.html

I hope this helps,

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie