Re: 7.2b Timestamp

Dave Smith <dave@candata.com> writes:
> Has some thing changed with the timestamp function since 7.0

The word "timestamp" is more reserved than it used to be, because
7.2 adds support for SQL92 timestamp precision options ---
timestamp(6) is now a type name, not a function call.

This means you need to write
    select "timestamp"(date '1998-02-24', time '23:07');
to get the result you are after.  Pain in the neck, I agree.

Actually, if the result you are after is timestamp with time zone,
you might try
    select timestamptz(date '1998-02-24', time '23:07');
to avoid needing quotes.

            regards, tom lane