Обсуждение: one byte data type

Hi gang,

Is there a datatype that means "one byte"? I'm importing a database from 
SQL Server, and some of the rows there are of this type. When I convert 
them to int2, I have discrepancies with the program that uses the 
database (OLE DB uses binary mode transfers, so the size of the variable 
is important beyond it's legal range).
            Shachar

-- 
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/

Shachar Shemesh <psql@shemesh.biz> writes:
> Is there a datatype that means "one byte"?

You might be able to use the "char" type (note the quotes).  I am not
sure how well it will cope with storing zeroes (nulls) though.
        regards, tom lane

Tom Lane wrote:

>Shachar Shemesh <psql@shemesh.biz> writes:
>  
>
>>Is there a datatype that means "one byte"?
>>    
>>
>
>You might be able to use the "char" type (note the quotes).  I am not
>sure how well it will cope with storing zeroes (nulls) though.
>
>            regards, tom lane
>  
>
Hmm, this will also screw up textual queries. Not important for this 
particular case, but not a good general solution. What are the chances 
of adding such a type for 7.4.2?
         Shachar
P.S.
Notice how this message arrives directly as well, despite spam filters.

-- 
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/