Re: int8 becames string in BDE :-(

----- Original Message -----
From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "SZUCS Gábor" <surrano(at)mailbox(dot)hu>
Cc: <pgsql-odbc(at)postgresql(dot)org>; "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Sent: Wednesday, June 05, 2002 9:48 AM
Subject: RE: [ODBC] int8 becames string in BDE :-(

<<<
Ahh, I see. In that case I would not be opposed to such a change. However,
as Hiroshi points out in his reply, mapping int8 -> int4 may cause problems
when you do get numbers bigger than 2,147,483,647 but of course, that may
not apply to your situation.
>>>

Since our largest tables are ~100k rows and those candidate for joins are
even lesser, it's an acceptable restriction unless we join 3 tables without
where's. This is concerning count(). Other int8 results such as nextval and
currval are also out of suspicions: it is unlikely to have more than 2^31
lines in any table concerning human lifetime.

Thanks for Hiroshi for the positive response, we can't wait for the new
version ;)

G.
--
There are 10 kinds of people:
those who understand binary numbers and those who don't.