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