RE: [EXTERNAL] Re: Numeric data types

From: "Godfrin, Philippe E" <Philippe(dot)Godfrin(at)nov(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: [EXTERNAL] Re: Numeric data types
Date: 2020-08-31 22:20:51
Message-ID: SA0PR15MB39339347FEE44880DBF8FA4182510@SA0PR15MB3933.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Frankly, I’m not certain, I believe the developers are using a messaging intermediary.
pg

From: Bruce Momjian <bruce(at)momjian(dot)us>
Sent: Monday, August 31, 2020 5:19 PM
To: Godfrin, Philippe E <Philippe(dot)Godfrin(at)nov(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [EXTERNAL] Re: Numeric data types

On Mon, Aug 31, 2020 at 10:14:48PM +0000, Godfrin, Philippe E wrote:
> Fabulous, thanks much.

You still have not told us how you are transfering the data, so we can
be sure.

---------------------------------------------------------------------------

>
> From: Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>>
> Sent: Monday, August 31, 2020 4:56 PM
> To: Godfrin, Philippe E <Philippe(dot)Godfrin(at)nov(dot)com<mailto:Philippe(dot)Godfrin(at)nov(dot)com>>
> Cc: pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>
> Subject: Re: [EXTERNAL] Re: Numeric data types
>
>
>
> On Mon, Aug 31, 2020 at 05:32:23PM +0000, Godfrin, Philippe E wrote:
> > Thanks Bruce, I suppose you mean n32 -> n64 OK, but n64->n32 chance of 32-bit
> > overflow…
>
> Uh, I was thinking that your 32-bit values could roll over and the other
> end would be confused, but I can also see the 64-bit going above the
> 32-bit range. As long as everything stays < 32-bits, you should be
> fine. We don't transfer binary values very often.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>> https://momjian.us<https://momjian.us>
> EnterpriseDB https://enterprisedb.com<https://enterprisedb.com>
>
> The usefulness of a cup is in its emptiness, Bruce Lee
>

--
Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>> https://momjian.us<https://momjian.us>
EnterpriseDB https://enterprisedb.com<https://enterprisedb.com>

The usefulness of a cup is in its emptiness, Bruce Lee

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2020-08-31 22:31:04 Re: [EXTERNAL] Re: Numeric data types
Previous Message Bruce Momjian 2020-08-31 22:19:01 Re: [EXTERNAL] Re: Numeric data types