Обсуждение: RE: [GENERAL] big numbers
Hello Lorenzo,
PostgreSQL v6.4 which is, currently in Beta and scheduled for release
Oct. 1, is planned to have an IPV6 type (can't remember what it was
decided to call it). You might just want to grab the current snapshot
and see what it has to offer.
-DEJ
> Hello,
>
> How big a number can be stored as a integer in the lateset version of
> postgres. See i got some code to do IP management and since i am just
> using IPV4 addresses right now i am able to math operations on the
> octets w/o to much fuss, since each octet is just composed of 8 bits.
> But of course IPV6 is composed of 4-32 bit parts , or 1 - 128 bit
> number.
>
>
> -lorenzo
>
>
>
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> Hello Lorenzo, > > PostgreSQL v6.4 which is, currently in Beta and scheduled for release > Oct. 1, is planned to have an IPV6 type (can't remember what it was > decided to call it). You might just want to grab the current snapshot > and see what it has to offer. > -DEJ > The person who said they were going to work on the IP type has not responded to my requests for a status, and nothing has been added in that area in 6.4. Not sure what to do about it yet. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
Bruce Momjian <maillist@candle.pha.pa.us> writes: > The person who said they were going to work on the IP type has not > responded to my requests for a status, and nothing has been added in > that area in 6.4. That would be me. What I said was that it looked like the thing to do was to pick the best ideas the three implementations available, and that I, at least, would be doing that for my local needs. I still plan to do that, but having recently become a father for the first time, and having lots of projects going at work, I haven't found time yet. Unless someone beats me to it, I will be doing this soon, and probably within the next couple of weeks, but obviously not in time for the 6.4 beta period. Besides, I have no idea how to integrate a new type as a built-in type, so someone else would have to do that. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier"
> Bruce Momjian <maillist@candle.pha.pa.us> writes: > > > The person who said they were going to work on the IP type has not > > responded to my requests for a status, and nothing has been added in > > that area in 6.4. > > That would be me. What I said was that it looked like the thing to do > was to pick the best ideas the three implementations available, and > that I, at least, would be doing that for my local needs. I still > plan to do that, but having recently become a father for the first > time, and having lots of projects going at work, I haven't found time > yet. Unless someone beats me to it, I will be doing this soon, and > probably within the next couple of weeks, but obviously not in time > for the 6.4 beta period. Besides, I have no idea how to integrate a > new type as a built-in type, so someone else would have to do that. I would be glad to help with integrating it. We need a decision, people. Who do we want to do this, and how are we going to handle integrating this into the beta, if we want to? BTW, does pg_upgrade work for people. That may be a quick fix for the beta people to get these new system types WITHOUT dump/reload. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)