[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #7824: documentation bug: Extract DOW
From:       Pavan Deolasee <pavan.deolasee () gmail ! com>
Date:       2013-01-23 6:39:39
Message-ID: CABOikdPkX33-KJbbaUUWYVo-nLrc5a=g03J3kkkCDphSFouCJA () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<br><br><div class="gmail_quote">On Wed, Jan 23, 2013 at 2:10 AM,  <span \
dir="ltr">&lt;<a href="mailto:tim.romano@yahoo.com" \
target="_blank">tim.romano@yahoo.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

The following bug has been logged on the website:<br>
<br>
Bug reference:      7824<br>
Logged by:          Tim Romano<br>
Email address:      <a \
href="mailto:tim.romano@yahoo.com">tim.romano@yahoo.com</a><br> PostgreSQL version: \
9.2.2<br> Operating system:   Windows 7 x64<br>
Description:<br>
<br>
Documentation seems to indicate that only a Timestamp value is a valid<br>
argument to the Extract function when trying to get the DOW, but a Date also<br>
works:<br>
<br>
dow<br>
The day of the week (0 - 6; Sunday is 0) (for timestamp values only)<br>
<br clear="all"></blockquote><div><br>The document also mentions: \
<br>&quot;(Expressions of type <tt class="TYPE">date</tt> will be cast to  <tt \
class="TYPE">timestamp</tt> and can therefore be used as  \
well.)&quot;</div></div><br>ISTM that &quot;for timestamp values only&quot; means \
that a source of type interval or time can not b used. Other functions will also \
accept those additional types. I don&#39;t know if the documentation needs to make \
that more clear though.<br>

<br>Thanks,<br>Pavan<br><br>-- <br>Pavan Deolasee<br><a \
href="http://www.linkedin.com/in/pavandeolasee" \
target="_blank">http://www.linkedin.com/in/pavandeolasee</a>



[prev in list] [next in list] [prev in thread] [next in thread]