Thread: Interval with precision

Interval with precision

From
"W. Haslbeck"
Date:
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;

Walter


Re: Interval with precision

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of W. Haslbeck
> Sent: 15 May 2006 20:20
> To: pgadmin-support@postgresql.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.