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...
>
