Re: 7.2 -> 7.3 timespan, interval etc.

Am Don, 2003-06-05 um 08.04 schrieb Tom Lane:
> Nabil Sayegh <postgresql(at)e-trolley(dot)de> writes:
> > Some of our projects (7.2) use timespan() which for example evaluates:
> > SELECT timespan('5 seconds');
> > interval
> > ----------
> > @ 5 secs
>
> Oh? I get
>
> regression=# SELECT timespan('5 seconds');
> interval
> ----------
> 00:00:05
> (1 row)

Hm. Could be because of datestyle german.

> in 7.0, 7.1, and 7.2. I see this in the 7.0 release notes:
>
> * The date/time types datetime and timespan have been superseded by
> the SQL92-defined types timestamp and interval. Although there has
> been some effort to ease the transition by allowing PostgreSQL to
> recognize the deprecated type names and translate them to the new
> type names, this mechanism may not be completely transparent to
> your existing application.

Do you know of more datatypes that changed ?
Is it rather more (>10) types or just the above ?

thx
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de