| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | StOo <stuart(at)comodo(dot)net> |
| Cc: | "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | Re: [INTERFACES] i broke my int8 =( |
| Date: | 1999-04-13 06:18:51 |
| Message-ID: | 3712E1CB.898FFA21@alumni.caltech.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
> 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Dieckert | 1999-04-13 07:35:04 | Re: [INTERFACES] cant connect |
| Previous Message | Pablo Funes | 1999-04-12 21:19:37 | nonblocking lock? |