Postgres Pro
Downloads
Home   >   mailing lists

Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits - Mailing list pgsql-general

From Tom Lane
Subject Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Date
Msg-id 6830.1133556030@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits  ("Roger Hand" <RHand@kailea.com>)
List pgsql-general
Tree view 
"Roger Hand" <RHand@kailea.com> writes:
> I would be in favor of this change. What's the plan for anyone who
> may be currently using > 508 digits (if there is anyone!)?

You could store your data as text columns and do whatever arithmetic
you had in mind on the client side.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Next
From: Tom Lane
Date:
Subject: Re: [Fwd: Re: deadlock on the same relation]