Skip site navigation (1) Skip section navigation (2)

Re: Numeric 508 datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Numeric 508 datatype
Date: 2005-12-02 21:10:22
Message-ID: 7170.1133557822@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> If that gives the right answer then the NUMERIC code is off the hook,
>> and what you've got is a strange limitation on output column length.

> 	test=> select length((pow(10::numeric, 131071))::text);
> 	 length
> 	--------
> 	 131089
> 	(1 row)

> Looks good.  From psql I just tried:

> 	SELECT repeat('x', 4000);

> and got 4k x's, and SELECT repeat('x', 8000) returns 8k x's, so that works.

Curiouser and curiouser.  How about if you repeat 4k or 8k '1's?  If the
behavior is different for letters and digits then I'd look at the column
justification logic in psql's printing code.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-12-02 21:19:20
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 21:05:28
Subject: Re: Numeric 508 datatype

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-12-02 21:19:20
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 21:05:28
Subject: Re: Numeric 508 datatype

pgsql-general by date

Next:From: Bruce MomjianDate: 2005-12-02 21:19:20
Subject: Re: Numeric 508 datatype
Previous:From: Tom LaneDate: 2005-12-02 21:06:31
Subject: Re: createuser ignores stdin in 8.1.0?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group