Skip site navigation (1) Skip section navigation (2)

int8 type substitute ?

From: Jan Vicherek <honza(at)ied(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: int8 type substitute ?
Date: 1998-12-27 18:29:23
Message-ID: Pine.LNX.4.04.9812271322110.11035-100000@ann.ied.com (view raw or flat)
Thread:
Lists: 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 values be integers, it may
on some occasions return to me a decimal ? I.e. I would store something
like
 2814749767106569
and on retrieval it would return something like
 2814749767106568.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/


Responses

pgsql-hackers by date

Next:From: Jan VicherekDate: 1998-12-27 18:35:35
Subject: Re: int8 type substitute ?
Previous:From: Bruce MomjianDate: 1998-12-27 18:10:51
Subject: Re: [HACKERS] psql \d does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group