| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew - Supernews | 2005-03-23 21:26:55 | Re: BUG #1552: massive performance hit between 7.4 and 8.0.1 |
| Previous Message | Alvaro Herrera | 2005-03-23 21:25:05 | Re: Precision and scale of numeric column reported as value |