Re: Datetime and pgtypes.c

Hi,

First, the correct is ´timestamp with time zone´ and not
'timestamp without timezone'... Sorry.

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 I send a "create foo (foo datetime)", PG 7.3 reports
´datetime´ does not exist. I only execute this statments
in win-odbc and not directly in psql.

Can ODBC convert automatically ´datetime´
to timestamp with time zone' or I have to create this type in PG 7.3
to convert it ?

Very thank´s, Mr. Hiroshi.


> alexandre :: aldeia digital wrote:
>>
>> Mr. Hiroshi and all,
>>
>> Sorry for report this bug again...The ODBC does not
>> convert 'datetime' type to 'timestamp without timezone'
>> for PostgreSQL 7.3
>
> How do you convert the 'datetime' type concretely ?
> Is the converted type still 'datetime' or 'timestamp with
> time zone' ? Note that 'datetime' is never converted to
> 'timetstamp without time zone'.
>
> regards,
> Hiroshi Inoue
>     http://w2422.nsk.ne.jp/~inoue/