Re: FW: bitemporal functionality for PostgreSQL

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: FW: bitemporal functionality for PostgreSQL
Дата
Msg-id 1202163923.10057.817.camel@dogma.ljc.laika.com
обсуждение исходный текст
Ответ на Re: FW: bitemporal functionality for PostgreSQL  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-hackers
On Mon, 2008-02-04 at 20:50 +0000, Heikki Linnakangas wrote:
> Jeff Davis wrote:
> > Also, they use "period" to mean interval, and "interval" to mean
> > duration -- which is wrong, in my opinion; interval already has a well-
> > defined mathematical meaning.
> 
> Agreed, but that mistake actually originates from the SQL standard. The 
> SQL INTERVAL data type is really a duration, so I guess they had to come 
> up with a new term for interval in the mathematical meaning.

Fair enough. However, that is just an example of the SQL idiosyncrasies
that I was referring to.

I think that kind of thing gets in the way a lot more than it helps,
which is why I found Temporal Data and the Relational Model so
refreshing.

Regards,Jeff Davis





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59
Следующее
От: "Gevik Babakhani"
Дата:
Сообщение: TODO item:Allow to_date() and to_timestamp() accept localized month names