Re: Field types - Mailing list pgsql-general

From Tom Lane
Subject Re: Field types
Date
Msg-id 17501.1015354855@sss.pgh.pa.us
Whole thread Raw
In response to Field types  ("Pirtea Calin" <pcalin@rdsor.ro>)
List pgsql-general
"Pirtea Calin" <pcalin@rdsor.ro> writes:
> I tried inserting this in an int8 integer: 9223372036854775807 and failed.

How old a version are you using, on what platform?  It works for me:

regression=# create table foo (f1 int8);
CREATE
regression=# insert into foo values (9223372036854775807);
INSERT 1873745 1
regression=# select * from foo;
         f1
---------------------
 9223372036854775807
(1 row)

regression=#

            regards, tom lane

pgsql-general by date:

Previous
From: tfo@monsterlabs.com
Date:
Subject: psql \df and opaque functions
Next
From: "Pirtea Calin"
Date:
Subject: Re: Field types