From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | kar(at)webline(dot)dk |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] NUMERIC and Perl |
Date: | 1999-03-03 19:17:08 |
Message-ID: | m10IH8n-000EBQC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
>
> > Looks like not, unless I'm forgetting a feature...
>
> That's why I asked. So I hope it will be compatible with Perl's
> Math-BigInteger module.
NUMERIC isn't INTEGER data!
Well - you can define an attribute as NUMERIC(33,0) and all
values assigned to that column will be rounded to the closest
integer (an integer that can hold values up to 999
quintillions exactly). But as soon as you do calculations
with other values that have fractions, there will a decimal
point and digits after that appear in the result. Don't know
how Perl might respond to it. Maybe you need to round the
result explicitly on calculations.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Auer | 1999-03-04 00:00:45 | sort of anser to "what on earth does this mean?!?" |
Previous Message | Kaare Rasmussen | 1999-03-03 18:33:55 | Re: [HACKERS] NUMERIC and Perl |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Davis | 1999-03-03 19:50:12 | parser enhancement request for 6.5 |
Previous Message | Kaare Rasmussen | 1999-03-03 18:33:55 | Re: [HACKERS] NUMERIC and Perl |