Обсуждение: What's the difference between int2 and int16?

I found the uses of int2, int16 and other similiar types misleading
in PostgreSQL's source code. Sometime it is difficult to figure out
which should be prefered.

Maybe int2, int4, and int8 refer to database types, while int16, int32
and int64 refer to C data types. If this is the convention, maintenance
may be easier.

""William ZHANG" <na@na.na>" wrote in comp.databases.postgresql.hackers:

> I found the uses of int2, int16 and other similiar types misleading
> in PostgreSQL's source code. Sometime it is difficult to figure out
> which should be prefered.
> 
> Maybe int2, int4, and int8 refer to database types, while int16, int32
> and int64 refer to C data types. If this is the convention, maintenance
> may be easier.
       There's no difference:
               smallint = int2 = int16               integer = int4 = int32               largeint = int8 = int64
       The single-digit types represent the number of "bytes" used to store 
the data, while the double-digit types represne the number if "bits."

-- 
Randolf Richardson - rr@8x.ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.