/me goes red in face. 10 seconds after I sent this off I found
contrib/int8. That would answer one of my questions -- I.e. it would be
reasonably simple to add my own data type. If somebody feels like
answering the other questions too, please go ahead.
On Sun, 27 Dec 1998, Jan Vicherek wrote:
> 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
> 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 ?
> -- Gospel of Jesus is the saving power of God for all who believe --
> ## To some, nothing is impossible. ##
-- Gospel of Jesus is the saving power of God for all who believe --
## To some, nothing is impossible. ##
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-12-27 19:17:15|
|Subject: Re: [HACKERS] Re: int8 type substitute ?|
|Previous:||From: Jan Vicherek||Date: 1998-12-27 18:29:23|
|Subject: int8 type substitute ?|