From: Tom Lane <tgl@sss.pgh.pa.us>
To: cio198@plasa.com
Cc: pgsql-sql@postgresql.org
Subject: Re: create view with numeric data
Date: Mon, 31 Mar 2003 12:52:50 -0500
Message-ID: <23915.1049133170@sss.pgh.pa.us> (raw)
In-Reply-To: <8d6dd4ad.0303310247.2dded41c@posting.google.com>
References: <8d6dd4ad.0303310247.2dded41c@posting.google.com>
cio198@plasa.com (cio198) writes:
> The problem is the numeric data in the view isn't limited to
> numeric(9,2) instead it become numeric(65535, 65531).
It should look like plain, unrestricted "numeric". Whatever is showing
you those bogus precision/scale fields is wrong. What client software
are you using anyway?
> Is there any way i can restrict it to numeric (9,2)
If you really want (9,2) and not just plain numeric, you can cast the
results of the sum operations to numeric(9,2).
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, cio198@plasa.com
Subject: Re: create view with numeric data
In-Reply-To: <23915.1049133170@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox