From: | "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Datetime and pgtypes.c (thanks) |
Date: | 2002-12-03 16:14:18 |
Message-ID: | 3517.200.225.214.1.1038932058.squirrel@webmail.ad2.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(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');
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2002-12-03 19:03:59 | Re: Can't get more than 255 chars out of memo field in Acc |
Previous Message | Tom Lane | 2002-12-03 14:45:35 | Re: Datetime and pgtypes.c |