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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
