This is a discussion on Interval with precision within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Hi, today I discovered the following bug / missing feature: > create table x (a interval, b interval hour ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |