Re: [BUGS] Bug in 8.1.5: cannot add literal timestamp value and a interval.

2006-10-20 Thread Tom Lane
"j.random.programmer" <[EMAIL PROTECTED]> 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'

[BUGS] Bug in 8.1.5: cannot add literal timestamp value and a interval.

2006-10-20 Thread j.random.programmer
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 inter