That's exactly what I meant with my first mail. IMO this is the correct
way to handle it.

Michael
--
Dr. Michael Meskes, Projekt-Manager    | topystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux!      | Tel: (+49) 2405/4670-44

> ----------
> From: 	Thomas G. Lockhart[SMTP:lockhart@alumni.caltech.edu]
> Sent: 	Freitag, 6. Februar 1998 16:53
> To: 	Bruce Momjian
> Cc: 	Michael Meskes; pgsql-hackers@postgresql.org
> Subject: 	Re: [HACKERS] Bug?
> 
> > I think it converts it to an integer, and then by the time it tries
> to
> > convert it, it has already chopped off the top of the number.  The
> only
> > fix for this would be to read all integers in as 64-bit integers,
> then
> > do the conversion, but that could be a performance problem.
> 
> Well, the other possibility is to try converting to float8 only if the
> int4
> conversion fails. If both fail, then throw an elog(ERROR). I have
> patches for
> this...
> 

Sun, 8 Feb 1998 11:16:22 +0100
"Meskes, Michael" <meskes@topsystem.de>
RE: [HACKERS] Bug?