Re: [EXTERNAL] Re: Numeric data types

On Mon, Aug 31, 2020 at 10:20:51PM +0000, Godfrin, Philippe E wrote:
> Frankly, I’m not certain, I believe the developers are using a messaging
> intermediary.

Oh, well, then you would need to find out if they are transfering the
value via text or binary. It is kind of hard to extract query results
as binary, but it is technically possible with binary COPY or triggers.

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

>
> 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>
> > Sent: Monday, August 31, 2020 4:56 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 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> https://momjian.us
> > EnterpriseDB https://enterprisedb.com
> >
> > The usefulness of a cup is in its emptiness, Bruce Lee
> >
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EnterpriseDB https://enterprisedb.com
>
> The usefulness of a cup is in its emptiness, Bruce Lee
>

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

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