Re: Interval with precision

> -----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.