Re: Numeric data types

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Godfrin, Philippe E" <Philippe(dot)Godfrin(at)nov(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Numeric data types
Date: 2020-08-31 16:54:23
Message-ID: 20200831165423.GA13608@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB 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 Godfrin, Philippe E 2020-08-31 17:32:23 RE: [EXTERNAL] Re: Numeric data types
Previous Message Godfrin, Philippe E 2020-08-31 16:38:05 Numeric data types