Re: Display format of "great" interval-Values in the query-result is not proper - Mailing list 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:031 day 00:01:0310 days 00:01:031 day 563:56:24563:56:24
(5 lignes)

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


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com