Hello all,
Just wondering if the datetime type was dropped on purpose from
PostgreSQL 7.3 ?
This is not an issue of course, I'll be using timestamp, but it's
weird having that dropped.
-------------------------------
-- On PostgreSQL 7.2:
-------------------------------
howe=# select version(); version
-----------------------------------------------------------------------PostgreSQL 7.2.1 on i386-portbld-freebsd4.6.2,
compiledby GCC 2.95.3
(1 row)
howe=# create table a(b datetime);
CREATE
howe=# \d a Table "a"Column | Type | Modifiers
--------+-----------------------------+-----------b | timestamp without time zone |
-------------------------------
-- On PostgreSQL 7.3:
-------------------------------
howe=# select version (); version
---------------------------------------------------------------------PostgreSQL 7.3b3 on i386-unknown-freebsd4.4,
compiledby GCC 2.95.3
(1 row)
howe=# create table a(b datetime);
ERROR: Type "datetime" does not exist
-------------
Best regards,Steve Howe mailto:howe@carcass.dhs.org