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, compiled by 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, compiled by 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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to