Thomas Lockhart writes:
> > peter=# SELECT EXTRACT(DOW FROM TIME '20:38:40');
> > ERROR: Interval units 'dow' not recognized
> > The expression is nonsensical, but so is the result.
>
> Hmm. Why is the result nonsensical? "day of week" does not have meaning
> for intervals, so it should not be recognized, right?
It's the "interval" part that's troubling me, since it appears nowhere in
the original expression.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter