Request a Demo
Home   >   mailing lists

Double types - Mailing list pgsql-general

From Hall, Samuel L (Sam)
Subject Double types
Date
Msg-id 69751890A64B3241A83BDB52A30BF29D010090@US70UWXCHMBA05.zam.alcatel-lucent.com
Whole thread Raw
Responses Re: Double types
List pgsql-general
Tree view

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?

Attachment

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: checkpoint_timeout and archive_timeout
Next
From: Rafal Pietrak
Date:
Subject: Re: foreign key from array element