Re: Display format of "great" interval-Values in the query-result is not proper

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Andreas Kutschke <Andreas(dot)Kutschke(at)edag(dot)de>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Display format of "great" interval-Values in the query-result is not proper
Date: 2010-07-16 09:54:43
Message-ID: 4C402C63.9070001@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Le 16/07/2010 11:13, Andreas Kutschke a écrit :
> * Platform: Windows XP 32
> * Language: German
> * Distribution: binary
> * Version: 1.10.3
> * Problem: Display format of "great" interval-Values in the
> query-result:
>
> -> only the first 24 hours are converted into days.
>

AFAICT, this is not an issue with pgAdmin, but with PostgreSQL. I have
the same display with psql:

b1=# select * from t3;
i
------------------
00:00:03
1 day 00:01:03
10 days 00:01:03
1 day 563:56:24
563:56:24
(5 lignes)

It depends on the way I put them on the table.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2010-07-16 13:32:16 Re: [Fwd: [TESTERS] pgAdmin 1.12.0 Beta 3 - Error viewing Server-Status]
Previous Message Ashesh Vashi 2010-07-16 09:49:36 Re: [Fwd: [TESTERS] pgAdmin 1.12.0 Beta 3 - Error viewing Server-Status]