Very, very thanks, Tom!
Functions perfectly! :)
My scripts is auto-genarate by a case tool and the
scripts change constantly...
> "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 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');
> 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
pgsql-odbc by date
|Next:||From: Jeff Eckermann||Date: 2002-12-03 19:03:59|
|Subject: Re: Can't get more than 255 chars out of memo field in Acc|
|Previous:||From: Tom Lane||Date: 2002-12-03 14:45:35|
|Subject: Re: Datetime and pgtypes.c |