... - Mailing list pgsql-hackers
From | root@blik.samara.su (Samara CIT) |
---|---|
Subject | ... |
Date | |
Msg-id | 199812291025.OAA19523@blik.samara.su Whole thread Raw |
List | pgsql-hackers |
>From [194.58.47.100]!mcit.aris.ru!hub.org!owner-pgsql-hackers Mon Dec 28 10:36:11 GMT 1998 remote from doom Received: from mcit.aris.ru ([194.58.47.100]) by doom.samara.su with SMTP id AA00380 (5.65/IDA-simtel for <evg@relay1.cit.ru>);Mon, 28 Dec 1998 10:36:11 +0400 Received: from hub.org by mcit.aris.ru with ESMTP id VAA16636; (8.8.5-MVC-230497/vak/1.9) Sun, 27 Dec 1998 21:39:34 +0300(MSK) Received: from localhost (majordom@localhost)by hub.org (8.9.1/8.9.1) with SMTP id NAA25039;Sun, 27 Dec 1998 13:36:43 -0500(EST)(envelope-from owner-pgsql-hackers@hub.org) Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Sun, 27 Dec 1998 13:36:35 +0000 (EST) Received: (from majordom@localhost)by hub.org (8.9.1/8.9.1) id NAA24939for pgsql-hackers-outgoing; Sun, 27 Dec 1998 13:36:30-0500 (EST)(envelope-from owner-pgsql-hackers@postgreSQL.org) Received: from enrico.ied.com (IDENT:root@miranda.uwaterloo.ca [129.97.130.69])by hub.org (8.9.1/8.9.1) with ESMTP id NAA24923for<pgsql-hackers@postgreSQL.org>; Sun, 27 Dec 1998 13:35:58 -0500 (EST)(envelope-from honza@ied.com) Received: from ann.ied.com (honza@ann.ied.com [192.168.200.20])by enrico.ied.com (8.8.7/8.8.7) with ESMTP id NAA28127for<pgsql-hackers@postgreSQL.org>; Sun, 27 Dec 1998 13:35:02 -0500 Date: Sun, 27 Dec 1998 13:35:35 -0500 (EST) From: Jan Vicherek <honza@ied.com> To: pgsql-hackers@postgreSQL.org Subject: [HACKERS] Re: int8 type substitute ? In-Reply-To: <Pine.LNX.4.04.9812271322110.11035-100000@ann.ied.com> Message-Id: <Pine.LNX.4.04.9812271330100.3549-100000@ann.ied.com> Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-pgsql-hackers@postgreSQL.org Precedence: bulk /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. Jan On Sun, 27 Dec 1998, Jan Vicherek wrote: > > 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/ > > -- 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: