Skip site navigation (1) Skip section navigation (2)

Re: Datetime and pgtypes.c (thanks)

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 (view raw or flat)
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




pgsql-odbc by date

Next:From: Jeff EckermannDate: 2002-12-03 19:03:59
Subject: Re: Can't get more than 255 chars out of memo field in Acc
Previous:From: Tom LaneDate: 2002-12-03 14:45:35
Subject: Re: Datetime and pgtypes.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group