Re: Configuring for 64-bit integer date/time storage?

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Configuring for 64-bit integer date/time storage?
Date: 2002-03-25 03:07:23
Message-ID: 3C9E946B.57E2F9F6@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > I've got patches to enable storage of date/time values as integers
> > rather than as floating point numbers, as discussed earlier.
> I'd like to know first what the overall plan for this feature is.

My feeling is that the int64 implementation will be "better". But I
*don't* know how many platforms support that data type, and I'm not yet
sure if there will be a measurable performance difference on (some?)
platforms.

I'd expect that we could form a consensus on the best default over the
next couple of months. In either case, the option should be selectable,
otherwise some of us would have trouble testing the feature set, right?

Did you catch the questions on dealing with HAVE_LONG_INT_64,
HAVE_LONG_LONG_INT_64, and INT64_IS_BUSTED? I'd like to be able to
enable/disable integer date/time storage in configure, so some notion of
"do I have some kind of 64 bit integer?" seems to be desirable in
configure itself.

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-03-25 03:24:35 Re: SET NULL / SET NOT NULL
Previous Message Peter Eisentraut 2002-03-25 02:22:12 Re: Configuring for 64-bit integer date/time storage?