Re: storage size of "bit" data type..

[Decibel! <decibel@xxxxxxxxxxx>]

On Dec 6, 2007, at 5:19 PM, Vyacheslav Kalinin wrote:
> > It needs to store the number of bits present as well
>
> Couldn't that be reduced to 1 byte that'd say how many bits count  
> in the last byte?
>
> > Only in the sense that numeric also has to store some meta data  
> as well like
> the weight and display precision.
>
> Is it really necessary to store display precision when it can be  
> taken from the table column definition?


Two problems...

1) CREATE TABLE n(n numeric);

2) The knowledge of extra type information (ie: the numbers in char()  
or numeric()) don't extend deeply enough into the code. This is part  
of why char() uses the exact same storage mechanism as varchar().
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828

<<attachment: smime.p7s>>