Re: [HACKERS] Upgrades for 6.4.1

> > > > * add DECIMAL, NUMERIC, DOUBLE PRECISION, BIT, BIT VARYING
> > >
> > > We've got DOUBLE PRECISION, DECIMAL, and NUMERIC (the latter two are
> > > brain-damaged though)
> >
> > Removed.
>
> If it's brain-damaged should'nt it be justr Replaced instead of Removed

NUMERIC and DECIMAL are identical, but should be different
from INTEGER (what they are in Postgres for now).

All databases share the definition

NUMERIC [(precision [, scale] )]

And NUMERIC (NUMBER in Oracle :-) is defined as a datatype
that uses exact representation of arbitrary precise numbers.
But everyone has different legal value ranges and defaults
for it. The ranges for the precision (number of total
digits) varies from 38 (Oracle) to over 1000 sometimes.

I'll hack around a little on it to see what's possible for
us.

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) #