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

• Re: Numeric 508 datatype at 2005-12-02 20:59:36 from Bruce Momjian

Responses

• Re: Numeric 508 datatype at 2005-12-02 21:19:20 from Bruce Momjian

pgsql-hackers by date

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

pgsql-patches by date

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

pgsql-general by date

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