Re: [pgadmin-support] getting NaN in the table

2013-11-21 Thread Basil Bourque
(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 vagu

[pgadmin-support] getting NaN in the table

2013-11-18 Thread Deven Thaker
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,