Re: [HACKERS] Upgrades for 6.4.1 - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] Upgrades for 6.4.1
Date
Msg-id m0zr4z8-000EBPC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] Upgrades for 6.4.1  (Hannu Krosing <hannu@trust.ee>)
Responses Re: [HACKERS] Upgrades for 6.4.1  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
> > > >         * 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) #

pgsql-hackers by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [HACKERS] Upgrades for 6.4.1
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] MVCC works in serialized mode!