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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
