Double types

From: "Hall, Samuel L (Sam)" <sam(dot)hall(at)alcatel-lucent(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Double types
Date: 2012-09-18 21:25:43
Message-ID: 69751890A64B3241A83BDB52A30BF29D010090@US70UWXCHMBA05.zam.alcatel-lucent.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have an application that writes an Excel Spreadsheet to postgres. For the values that go in number fields, I check the Excel values for dbnull and set the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws an error "format specifier was invalid" If I do this: cmd.Parameters(9).Value = convert.todouble(0) then it works fine.
Visual Basic 2010, Postgres 9.1, npgsql 2.0.12.0

Could somebody please explain this behavior?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2012-09-18 21:30:35 Re: foreign key from array element
Previous Message Jeff Janes 2012-09-18 21:10:45 Re: checkpoint_timeout and archive_timeout