Re: Interval with precision

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of W. Haslbeck
> Sent: 15 May 2006 20:20
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Interval with precision
> 
> Hi,
> 
> today I discovered the following bug / missing feature:
> 
> > create table x (a interval, b interval hour to minute);
> 
> in psql it looks ok:
> 
> \d x
>               Tabelle >public.x<
>  Spalte |           Typ           | Attribute
> --------+-------------------------+-----------
>  a      | interval                |
>  b      | interval hour to minute |
> 
> but in PgAdminIII (I checked 1.4.1 and 1.4.2 on Linux and 
> win32) I get:
> 
> CREATE TABLE x
> (
>   a interval,
>   b interval(201392127)
> )
> WITHOUT OIDS;

Hi Walter,

This should be fixed by one of my TODO items to cleanup the type
formatting which I hope to get to within the next couple of weeks.
Thanks for the report.

Regards, Dave.