Re: Bad interval conversion?

Alex Hunsaker <badalex@gmail.com> writes:
> It only happens if you have integer date times on... seems to have
> gotten introduced by
> http://archives.postgresql.org/pgsql-committers/2008-03/msg00406.php

Uh, no, fsec_t was int32 before that (look towards the bottom of the
diff).  I'm fairly dubious that fixing it as you suggest is a one-liner
--- the width of fsec_t is something that seems likely to propagate all
over.  A narrower fix for whatever this specific problem is seems safer.

            regards, tom lane