| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "j(dot)random(dot)programmer" <javadesigner(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug in 8.1.5: cannot add literal timestamp value and a interval. |
| Date: | 2006-10-20 22:17:11 |
| Message-ID: | 18877.1161382631@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"j.random.programmer" <javadesigner(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-10-21 03:53:24 | Re: BUG #2710: Intermittent hangs on sequence generation |
| Previous Message | j.random.programmer | 2006-10-20 21:51:52 | Bug in 8.1.5: cannot add literal timestamp value and a interval. |