Re: EXTRACT broken

Thomas Lockhart writes:

> Oh yeah. We don't have a date_part(units, time) function defined, so it
> is getting converted to interval (which in other contexts *does* have
> some usefulness as a "time equivalent").

You're going to have an extremely hard time convincing me of that.

> We could fairly easily define a date_part() for the time and timetz data
> types.

I had figured that time would be cast to timestamp.  Which is probably
what it used to do.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter