Обсуждение: Bug in 8.1.5: cannot add literal timestamp value and a interval.

Hi:

This is a regression bug between 8.1.4 and 8.1.5

  '2006-10-20 00:00:00' + interval '5' second

With 8.1.4, the following worked fine. However with
8.1.5, this
gives the following error.

test=# select ('2006-10-20 00:00:00' + interval '5'
second) ;
ERROR:  invalid input syntax for type interval:
"2006-10-20 00:00:00"

With 8.1.5, the following works:

test=# select (timestamp '2006-10-20 00:00:00' +
interval '5' second);
      ?column?
---------------------
 2006-10-20 00:00:05
(1 row)


As you can see, we have to specify 'timestamp' before
a literal
timestamp value. That's pretty hokey. Is this a bug or
am I
missing something (and if so, why did a literal
timestamp value not
preceded by "timestamp" work fine in earlier versions
of postgres)?

Best regards,
--j


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

"j.random.programmer" <javadesigner@yahoo.com> writes:
> This is a regression bug between 8.1.4 and 8.1.5

>   '2006-10-20 00:00:00' + interval '5' second

No, I don't think so.  Every PG release back to the beginning of time
will think that is an interval + interval addition.  That's one of the
system's basic heuristics for resolving the type of unmarked string
literals: if it's in a binary operator expression, assume it's the same as
the known type on the other side of the operator.  The only way it would
act differently would be if there was no interval + interval operator,
but one has existed since at least 7.0 (the oldest version I have handy
to check).

            regards, tom lane