----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "SZUCS Gábor" <surrano@mailbox.hu>
Cc: <pgsql-odbc@postgresql.org>; "Hiroshi Inoue" <Inoue@tpf.co.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.