Thanks Bruce, I suppose you mean n32 -> n64 OK, but n64->n32 chance of 32-bit overflow... pg
From: Bruce Momjian <br...@momjian.us> Sent: Monday, August 31, 2020 11:54 AM To: Godfrin, Philippe E <philippe.godf...@nov.com> Cc: pgsql-gene...@postgresql.org Subject: [EXTERNAL] Re: Numeric data types On Mon, Aug 31, 2020 at 04:38:05PM +0000, Godfrin, Philippe E wrote: > Greetings Listees (frist time poster!) > > > > Considering the difference between 64 bit and 32 bit numeric datatypes. We > have > source databases that are running 32 bit. They send their data to a larger > cluster that is running 64 bit. Should there be something special done in > order > to accommodate the difference? How is the data sent? In almost every case, the translation should work fine. I think 32-bit overflow should be your only concern here. -- Bruce Momjian <br...@momjian.us<mailto:br...@momjian.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
