km <km(at)mrna(dot)tn(dot)nic(dot)in> writes:
> i have compiled postgres 8.1.4 even if configure didnt detect
> int8,uint8,int64 and uint64. i have tried to create a test table with
> datattype as int64 , but it says no such datatype, same is with uint8
> an uint64 datatypes.
At the SQL level, these datatypes are named after byte sizes not bit
sizes, ie, int2, int4, int8. Or you might prefer smallint, int, bigint.
There are no unsigned types.
regards, tom lane