""William ZHANG" <[EMAIL PROTECTED]>" 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 - [EMAIL PROTECTED]
Vancouver, British Columbia, Canada
Please do not eMail me directly when responding
to my postings in the newsgroups.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
