Any comments on this one?
> Raul Chirea <[EMAIL PROTECTED]> writes:
> > So, it seems to be a parser difficulty (bug) to correctly determine
> > the type of a numeric constant with decimals (like 99.9).
>
> Yes. You can find more about this in the pgsql-hackers archives.
> We've been aware of t
Raul Chirea <[EMAIL PROTECTED]> writes:
> This problem bothers me because if one (me, for example ;-) tries to
> use a client program that compose the select automaticaly (i.e. Delphi
> table component) and there is no way to manually cast that expression
> (i.e. "where = 12345.67::numeric") this
Tom Lane wrote:
>> > Raul Chirea <[EMAIL PROTECTED]> writes:
>> > > So, it seems to be a parser difficulty (bug) to correctly determine
>> > > the type of a numeric constant with decimals (like 99.9).
>> >
>> > We've been aware of the problem for a while but are unsure as yet
>> > how to solve i
Dirk Lutzebaeck <[EMAIL PROTECTED]> writes:
> $ pg_dump cs1 -o > /tmp/x.dump
> parseNumericArray: bogus number
IIRC, this is what you see when you run a 6.5 pg_dump against a 7.0
database (or perhaps it was vice versa).
There's been talk of putting stricter version checking into pg_dump,
but tha
Bruce Momjian writes:
> This is terrible. I can't imagine how people use this without terrible
> problems. Why don't we get more bug reports about this?
Maybe this relates to this too:
$ pg_dump cs1 -o > /tmp/x.dump
parseNumericArray: bogus number
pg_dump aborts then. This is on 7.0 on Lin
> Raul Chirea <[EMAIL PROTECTED]> writes:
> > So, it seems to be a parser difficulty (bug) to correctly determine
> > the type of a numeric constant with decimals (like 99.9).
>
> Yes. You can find more about this in the pgsql-hackers archives.
> We've been aware of the problem for a while but a
Raul Chirea <[EMAIL PROTECTED]> writes:
> So, it seems to be a parser difficulty (bug) to correctly determine
> the type of a numeric constant with decimals (like 99.9).
Yes. You can find more about this in the pgsql-hackers archives.
We've been aware of the problem for a while but are unsure as
Hi there,
It happened to me, too !
Denis Sbragion wrote:
> pgsql=# UPDATE aocc SET controvalore_ord = 320.5 WHERE controvalore_ord = 320.5
> 00 AND oid = 21624;
> ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
> You will have to retype this query using an e
