CODEWITHSUNDEEP
postgresqlmonosqldatatypesnpgsql
Neppomuk
Neppomuk

Reputation: 1210

Npgsql returns the content of an interval field as a .net string object

I am currently struggling with a strange issue with my Npgsql driver: I would like to fetch interval values from a table in my database (PostgreSQL 9.3-3.1.2) for some calculations on the client side, but when I get it returned in a field of an IDataReader object, it's a System.String instead. Why? The docs say it shall be a System.TimeSpan object!

BTW, I am using the Npgsql driver contained in the openSuSE package mono-data-postgresql-3.12.1-6.9.x86_64. Shall I update it?

Thank you for any useful hints!

Upvotes: 0

Views: 137

Answers (1)

Shay Rojansky
Shay Rojansky

Reputation: 16702

I'm not sure what version of Npgsql you get in that package, but there's a very good chance it's extremely outdated. The preferred way to get Npgsql (and most other .NET packages) is via nuget, where you can install the latest (3.0.3), this should resolve your issue.

Upvotes: 1

Related Questions