Re: Datetime and pgtypes.c

"alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> writes:
> I have a lot of CREATE scripts using datetime
> correctly in PG <= 7.2.3...PG convert automaticaly
> to timestamp with time zone.
> But I cant change the datetime in these scripts and
> PG 7.3 remove this type.

If you can't afford the time to fix your scripts, you could use a DOMAIN
as a form of type alias:

regression=# create domain datetime timestamp with time zone;
CREATE DOMAIN
regression=# create table fooey (f1 datetime);
CREATE TABLE
regression=# select datetime('now');
datetime
-------------------------------
2002-12-03 09:44:46.458992-05
(1 row)

There might be some cases where this doesn't help, but I think it will
work for most of the common uses.

regards, tom lane