On Wed, Jan 23, 2013 at 2:10 AM, <tim.romano@yahoo.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7824
> Logged by: Tim Romano
> Email address: tim.romano@yahoo.com
> PostgreSQL version: 9.2.2
> Operating system: Windows 7 x64
> Description:
>
> Documentation seems to indicate that only a Timestamp value is a valid
> argument to the Extract function when trying to get the DOW, but a Date
> also
> works:
>
> dow
> The day of the week (0 - 6; Sunday is 0) (for timestamp values only)
>
>
The document also mentions:
"(Expressions of type date will be cast to timestamp and can therefore be
used as well.)"
ISTM that "for timestamp values only" means that a source of type interval
or time can not b used. Other functions will also accept those additional
types. I don't know if the documentation needs to make that more clear
though.
Thanks,
Pavan
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee