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@debis.com (Jan Wieck) #