Re: DOes PostgreSQL support UInt64?

On Tue, 30 Oct 2001, Meenatchi Anbuchelvan wrote:

> Does anyone know if Postgres supports UInt64. The
> document says postgres supports bigint(which
> corresponds to Int64), but I am not sure if it
> supports Unsigned int 64. Also when i tried doing a
I don't believe there's built in support for unsigned
integers.

> create table table1(name varchar(20), num bigint), i
> get an error message which says
> "ERROR: Unable to locate type name 'bigint' in
> catalog".
> And the postgres doc says "The bigint type may not be
> available on all platforms since it relies on compiler
> support for eight-byte integers"
I think this means if your compiler doesn't have built in
support for an 8 byte integer (long long, or equivalent),
it's going to build without bigint support. Also, what
version are you using?

> Also i would like to know where to look for a mapping
> between SQL_Binary and a corresponding data type in
> postgres.
I'm not sure what SQL_Binary is, but you may want to look
at bytea.