Re: [GENERAL] storage size of "bit" data type..

[Decibel!]

On Dec 6, 2007, at 5:19 PM, Vyacheslav Kalinin wrote:

> It needs to store the number of bits present as well




the weight and display precision.

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 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);


--
Decibel!, aka Jim C. Nasby, Database Architect  [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828

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().

smime.p7s
Description: S/MIME cryptographic signature