Re: [SQL] What's wrong with my date/interval arithmetic?

2004-03-01 Thread Wojtek
the questions why there is a difference in results and why it is exactly one day. The "timestamp without time zone" arithmetic should produce correct results when all operations are done _within_ that data type (without mixing types), yet I'm getting this one day discrepancy. puzzled Wojtek ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] What's wrong with my date/interval arithmetic?

2004-03-01 Thread Wojtek
Is this a bug or am I doing something worng? thanks for any thoughts about this problem, Wojtek P.S. postingblogdate is of type "timestamp without time zone" ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org