Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Roger Hand" <RHand(at)kailea(dot)com>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Date: 2005-12-02 20:40:30
Message-ID: 6830.1133556030@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Roger Hand" <RHand(at)kailea(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-12-02 20:44:11 Re: Numeric 508 datatype
Previous Message Tom Lane 2005-12-02 20:37:56 Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits