Hi Tom,
Very, very thanks, Tom!
Functions perfectly! :)
My scripts is auto-genarate by a case tool and the
scripts change constantly...
Alexandre
> "alexandre :: aldeia digital" <alepaes@aldeiadigital.com.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 can´t 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
