"Ron St.Pierre" <rstpierre@syscor.com> writes:
> Example - when I run the following:
> select timestamp(date '1998-02-24',time '23:07')
> I get the following error:
> parse error at or near "date"
"timestamp" is a reserved word these days, so to use it as a function
name you must double-quote it.
regression=# select timestamp(date '1998-02-24',time '23:07');
ERROR: parser: parse error at or near "date" at character 18
regression=# select "timestamp"(date '1998-02-24',time '23:07');
timestamp
---------------------
1998-02-24 23:07:00
(1 row)
Kinda messy, but the alternative of choosing a different name for this
function doesn't seem very palatable either...
regards, tom lane