Re: getting NaN in the table
От
Basil Bourque
Тема
Re: getting NaN in the table
Дата
Msg-id
13DD84BB-F2BD-4096-8509-C3BA87ADF739@pobox.com
Ответ на
getting NaN in the table (Deven Thaker)
Список
Дерево обсуждения
getting NaN in the table Deven Thaker <devenmthaker@gmail.com>
Re: getting NaN in the table Basil Bourque <basil.bourque.lists@pobox.com>
(1) Why are you posting on the pgAdmin support list? Is the problem happening inside pgAdmin?
(2) Just a wild guess… I've not seen this with Postgres, but with in past experience with another database system we were getting NaNs caused by users pasting text into our custom app. As I recall vaguely, this happened typically when copying from their email app. And only on MS Windows computers. Also, Windows seems susceptible to users inputting crazy values involving holding down the Control key. Anyways, I suggest checking the keystroke-filters and data-validation you may have on inputs to the data in question.
--Basil Bourque
On Nov 18, 2013, at 08:06, Deven Thaker <devenmthaker@gmail.com> wrote:
Hi,One of the columns of table is getting populated with NaN. When i checked all scripts which updates this table, found that we never do any division but still it populates NaN values in the column (double precision) . Surprisingly behavior is very random and difficult to reproduce. Any pointer, help would be appreciatedEnvironmentPostgre version 9.1Windows 7.0
В списке pgadmin-support по дате отправления
