int8 type substitute ? - Mailing list pgsql-hackers

From Jan Vicherek
Subject int8 type substitute ?
Date
Msg-id Pine.LNX.4.04.9812271322110.11035-100000@ann.ied.com
Whole thread Raw
Responses Re: int8 type substitute ?  (Jan Vicherek <honza@ied.com>)
List pgsql-hackers
Hello,
  I'm looking for a int8-like type or equivalent substitute.
  float8 is the first one that comes to mind, but a question arises : isn't there a chance that if I store float8
valuesbe integers, it may
 
on some occasions return to me a decimal ? I.e. I would store something
like2814749767106569
and on retrieval it would return something like2814749767106568.999999999998 instead of 2814749767106569 ?
  If there is such danger, what other suitable 8 byte data type (other
than char(8)) would there be in PG to give me the ablility to store
integers > 2^32 ?
 Or is it quite fast, easy, simple and performance-effective to add my
own 'int8' data type ?
   Thanx,
     Jan

-- Gospel of Jesus is the saving power of God for all who believe --               ## To some, nothing is impossible.
##                 http://Vicherek.Waterloo.on.ca/
 



pgsql-hackers by date:

Previous
From: Terry Mackintosh
Date:
Subject: regression test: triggers fial:
Next
From: Jan Vicherek
Date:
Subject: Re: int8 type substitute ?