Re: 9.2 timestamp function syntax error - Mailing list pgsql-general

Adrian Klaver <adrian.klaver@gmail.com> writes:
> This does not work:

> test=> select timestamp(now()::timestampz);
> ERROR:  syntax error at or near "now"

timestamp(something) is a type name.  Per the comment in gram.y:

 * The type names appearing here are not usable as function names
 * because they can be followed by '(' in typename productions, which
 * looks too much like a function call for an LR(1) parser.

            regards, tom lane