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

Re: Precision and scale of numeric column reported as value

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Sergio Lob <Sergio_Lob(at)iwaysoftware(dot)com>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-bugs(at)postgresql(dot)org,Ephraim Spravtsev <Ephraim_Spravtsev(at)ibi(dot)com>
Subject: Re: Precision and scale of numeric column reported as value
Date: 2005-03-23 21:26:39
Message-ID: 20050323132342.Q91219@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, 23 Mar 2005, Sergio Lob wrote:

> Precision is the number of total digits in the number. Scale is the
> number of  fractional digits.
> For instance, a column defined as NUMERIC(10,3)  should return
> precision=10, scale=3. The error only occurs for a column defined as
> NUMERIC  (without precision or scale specified). Presumably, there is a
> default precision and scale assigned to the column by postgreSQL, which
> is not -1.

IIRC, there is not a default precision and scale assigned to the column.
It's treated as having an unspecified precision and scale.

In response to

pgsql-bugs by date

Next:From: Andrew - SupernewsDate: 2005-03-23 21:26:55
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Previous:From: Alvaro HerreraDate: 2005-03-23 21:25:05
Subject: Re: Precision and scale of numeric column reported as value

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