On Fri, Jul 29, 2011 at 11:18 AM, Johann 'Myrkraverk' Oskarsson
<johann@2ndquadrant.com> wrote:
> Hi all,
>
> I just noticed that the USECS_* constants are not defined when the server
> is compiled without integer dates and timestamps.
>
> Explicitly, timestamp.h is
>
> #ifdef HAVE_INT64_TIMESTAMP
> #define USECS_PER_DAY INT64CONST(86400000000)
> #define USECS_PER_HOUR INT64CONST(3600000000)
> #define USECS_PER_MINUTE INT64CONST(60000000)
> #define USECS_PER_SEC INT64CONST(1000000)
> #endif
>
> Is there a particular reason for this? Even with float8 timestamps
> there are uses for these constants in extensions.
I don't see any particular reason not define them unconditionally.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company