On Wed, Dec 29, 2010 at 12:46 PM, Tom Lane wrote:
> Leslie S Satenstein writes:
>> A good compromise is to perhaps consider the following.
>
>> The bigint type should only be used if the integer range is insufficient,
>> because calculation with the latter is definitely faster.
>
> This doesn't
Leslie S Satenstein writes:
>> I tested and found the algorithm in Postgres to have
>> the day before January 1,0001 calculating as December
>> 31, even though the world calculates the day before
>> January 1,0001 as December 31,-0001.
>
>> 2) Is the algorithm in Postgres correct? I think
>>
Leslie S Satenstein writes:
> A good compromise is to perhaps consider the following.
> The bigint type should only be used if the integer range is insufficient,
> because calculation with the latter is definitely faster.
This doesn't seem to me to fix the basic problem, which is that "the
latt
Good morning Robert
I presume that you are the acting project manager, in the sense of vetting
changes or commentary. The pdf guide has only one statement concerning julian
dates. I feel that more is required.
Julian dates are used as follows.
Working days between two dates is (the differenc
--- On Wed, 12/29/10, Robert Haas wrote:
> From: Robert Haas
> Subject: Re: [DOCS] Words missing in the following txt
> To: "Leslie S Satenstein"
> Cc: pgsql-docs@postgresql.org
> Date: Wednesday, December 29, 2010, 6:45 AM
> On Sun, Dec 26, 2010 at 8:28 PM,
> Leslie S Satenstein
>
> wrote
On Mon, Dec 27, 2010 at 9:23 PM, Leslie S Satenstein
wrote:
> I found the Julian date code that is programmed in Postgres, to be accurate
> and fast except for one situation. But, I do have one or two questions. 1)
> Which calendar is being used?
>
> In the Gregorian Calendar, January 1, 0001 i
On Sun, Dec 26, 2010 at 8:28 PM, Leslie S Satenstein
wrote:
> In 8.1.1. Integer Types
>
> The ending sentence in the 2nd paragraph reads...
>
> The bigint type should only be used if the integer range is insufficient,
> because the latter is definitely faster.
>
> Integers are bigger or smaller,
