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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Vicherek | 1998-12-27 18:35:35 | Re: int8 type substitute ? |
Previous Message | Bruce Momjian | 1998-12-27 18:10:51 | Re: [HACKERS] psql \d does not work |