On Mon, 28 Jun 2004, Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > W.B.Hill wrote: > >> SELECT d+'45 days ago'::interval FROM test;
Yep - it's the clock's going forward that does it. Doh! The quick'n'dirty work around '45.3 days ago' was what I used but just a straight -45 is better. > BTW, since 7.3 there has been a date-plus-interval operator yielding > timestamp without time zone, which I believe Lockhart added specifically > to avoid the unwanted promotion to timestamptz in this scenario. > So the third answer is to update to something less ancient than PG 7.2. Debian Stable. Sigh. IT support policies. Whimper! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
