Darren King wrote:
>
>
> > abstime has been used since the beginning of (Unix) time in the
> > internals of Postgres, but I would suggest that it might be deprecated
> > as a user-level type.
>
> Do I hear a vote of doing the same with oid? I'd better quit while I'm at
^^^^^^^^^^^^^^^^^^^^^^^
> least close to even here. :) :)
And you hear my vote too!
>
> > Other comments?
>
> Coming from a math theory background, why are people so intent on separating
> date and time? They're both _time_ really... :) One datatype that contains
Just because I'm not interested about time in some cases.
And I don't like to use 'datetime >= _a_day_ and datetime < _next_day_'
to get records for a day using indices, because I can't use indices
for "TO_CHAR(datetime, 'DD-MM-YYYY') = _a_day_" (we can't use
functions in multi-column indices - currently, at least).
> both is the only "perfect" date or time type. (See what happens when I have
> too much coffee in the morning? :)
Vadim
------------------------------
