From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Datetime and pgtypes.c |
Date: | 2002-12-03 14:45:35 |
Message-ID: | 23240.1038926735@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
"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
From | Date | Subject | |
---|---|---|---|
Next Message | alexandre :: aldeia digital | 2002-12-03 16:14:18 | Re: Datetime and pgtypes.c (thanks) |
Previous Message | Dave Page | 2002-12-03 12:55:25 | Re: Free ODBC driver for linux ? ( NOT windows!) |