3 Replies Latest reply on Nov 27, 2012 9:42 PM by ravi.vankayala

    Database error 0x800004005: ERROR:invalid input syntax for double precision: "";

    Nathan Schofield

      I had this error when trying to refresh a data extract from PostgreSQL DB. I found this thread:




      I then found one variable in my workbook which I had changed from its default format of string to numeric. I changed this back and then the extract worked.


      Is this a bug? Is there anything I can do to not have to manually change the datatype back and forth every time I refresh?



      Nathan Schofield