From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: StOo <stuart@comodo.net>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] i broke my int8 =(
Date: Tue, 13 Apr 1999 06:18:51 +0000
Message-ID: <3712E1CB.898FFA21@alumni.caltech.edu> (raw)
References: <371230CF.721F4138@comodo.net>
> ive got an intresting problem with then int8 in postgres its not
> actually working properly as it goes out of range with a value like
> 2147483648 !!!! oops i need it to go just a bit higher!!! i think the
> build naffed up the int8 is there any way of checking this ??? any
> settings i
> may have missed or need to configure ???
You need to enter the values with a single quote around the string.
Otherwise, the number is interpreted as an int4 (and rejected) before
it would be converted to an int8. The quotes keep it as a string until
the right time...
- Tom
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, stuart@comodo.net
Subject: Re: [INTERFACES] i broke my int8 =(
In-Reply-To: <3712E1CB.898FFA21@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox