Re: Not able to update some rows in a table

Поиск
Список
Период
Сортировка
От Marco Fochesato
Тема Re: Not able to update some rows in a table
Дата
Msg-id CAECC44c87swS8RvZm1sbZCWrQZo=2oSs35AsvzEe8xzut46YZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Not able to update some rows in a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general



That seems like a remarkably strange definition of a primary key.
Are all of those columns really identification of an object, and
not properties of the object?

In any case, I'll bet a lot of money that your can't-update problem
is related to the fuzzy behavior of floating-point columns.  Just
because a float8 value prints out as "1.2345" doesn't mean that it'll
be considered equal to a value you write as "1.2345".  If this fact
astonishes you, you should likely switch to type numeric.

                        regards, tom lane
 
Dear Tom, you can bet all your money because you are right.
I drop the table and re-created using numeric instead double precision.
Now everything is ok, I can update every row of the table.
Thank you.

--
Marco Fochesato

В списке pgsql-general по дате отправления: