Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Roger Hand" <RHand@xxxxxxxxxx>
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 02 Dec 2005 15:40:30 -0500
Cc: "Bruce Momjian" <pgman@xxxxxxxxxxxxxxxx>, "Simon Riggs" <simon@xxxxxxxxxxxxxxx>, "PostgreSQL-general" <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to "Roger Hand" <RHand@xxxxxxxxxx> message dated "Fri, 02 Dec 2005 09:49:22 -0800"
In-reply-to: <DB28E9B548192448A4E8C8A3C1B1E475FC314E@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <DB28E9B548192448A4E8C8A3C1B1E475FC314E@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>

"Roger Hand" <RHand@xxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
  - From: Roger Hand

Prev by Date: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Next by Date: Re: [Fwd: Re: deadlock on the same relation]
Previous by thread: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Next by thread: accessing text of the query in a rule
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux