Just updated...
peter=# SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
ERROR: Timestamp with time zone units 'dow' not recognized
This is documented to work.
peter=# SELECT EXTRACT(DOW FROM TIME '20:38:40');
ERROR: Interval units 'dow' not recognized
The expression is nonsensical, but so is the result.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter