Field types

From: "Pirtea Calin" <pcalin(at)rdsor(dot)ro>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Field types
Date: 2002-03-05 18:27:57
Message-ID: 014801c1c473$9926e230$0100a8c0@dizzy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm new to PostgreSQL and after a week of going through the documentation
and looking at the database types i want to know if there is an Integer type
on
64 bits. Something like long long integer type. I found Int8 wich is
supposed
to be an integer on 8 bytes but it looks like a double precision to me.

I tried inserting this in an int8 integer: 9223372036854775807 and failed.
Since
it is my first contact with this rdbms i think i'm looking at the wrong
field type,
yet again i find no other 18 digits integer (64 bit integer is 19 digits
wide) to hold
a full longlonginteger (i also tried only 18 digits without any success).

Any hint as of where to look for would be very apreciated.
TIA

Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin(at)rdsor(dot)ro

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tfo 2002-03-05 18:39:52 psql \df and opaque functions
Previous Message Pirtea Calin 2002-03-05 18:11:53 Re: descending index