Re: Create Timestamp From Date and Time

"Ron St.Pierre" <rstpierre(at)syscor(dot)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