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.



Tue, 18 Nov 2003 18:03:27 +0800
"William ZHANG" <na@na.na>
What's the difference between int2 and int16?
""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.

Fri, 12 Dec 2003 19:59:00 +0000 (UTC)
Randolf Richardson <rr@8x.ca>
Re: What's the difference between int2 and int16?