Interval data is returned weird

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Interval data is returned weird

Post by aspirevishal » Sat 17 May 2008 02:09

Hi,

For a column returning interval data type of postgresql interval.
Datagridview shows weird data e.g

Code: Select all

"3 mons 27 days"
is displayed as

Code: Select all

27.00:00:00
Is that right ?
Last edited by aspirevishal on Mon 19 May 2008 16:26, edited 2 times in total.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Sat 17 May 2008 08:23

Please send me (alexeyman*crlab*com) or post here a small test project to reproduce the problem.
Include the definition of your own database objects.
We will investigate the problem.

aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Post by aspirevishal » Sat 17 May 2008 14:46

test data send. Please acknowledge

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Mon 19 May 2008 08:49

We have received the test data.
We are investigating this problem now.
I will contact you by email in the nearest time.
Could you please specify the versions/editions of:
- PostgreSQLDirect .NET;
- PostgreSQL server;
- OS;
- .NET Framework installed (is it MONO?).

aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Post by aspirevishal » Mon 19 May 2008 16:41

Could you please specify the versions/editions of:
- PostgreSQLDirect .NET 3.50.25
- PostgreSQL server; 8.2.4
- OS; windows xp pro sp3 , tried the same on sp2 results the same
- .NET Framework installed (is it MONO?) , MS .NET 2.0 sp1

and VS 2005

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Tue 20 May 2008 09:37

Hello,

I have sent you an email with solution.
Let me know if the problem is solved.

aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Post by aspirevishal » Tue 20 May 2008 15:52

No , the problem is stilll their . The interval comes with a trialling time . check the e-mail I have send you.

aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Post by aspirevishal » Thu 22 May 2008 05:06

should I expect something new ?

I mean is something cooking ,as far as this problem is concerned.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 22 May 2008 13:09

Please check you email.
The solution is to set a proper format for the column in the DataGridView.

aspirevishal
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Post by aspirevishal » Thu 22 May 2008 14:53

I have already tried that , moreover to best of my knowledge if no formatting is used in DefaultCellStyle property it should return the data as it is .


moreover you have the test case and you could have tried that yourself :shock:

later we could have discussed, how to make it work.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Fri 23 May 2008 09:36

Unfortunately, we cannot provide a general advice on using formatting in DataGridView because this topic is beyond the scope of our support program.
TimeSpan struct doesn't have native implemented formatting

Code: Select all

public struct TimeSpan : IComparable, IComparable, IEquatable

Post Reply