Postgres Pro
Downloads
Home   >   mailing lists

Thread: Missing date_trunc docs

Missing date_trunc docs

From
Eric Howe
Date:
In table 9-27 of the 9.2 docs:

    http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TABLE

There is an entry for date_trunc(text, timestamp) but no entry for date_trunc(text, interval). The full docs for
date_trunc:

    http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

do mention both the timestamp and interval forms of date_trunc but that's easy to miss if you're just scanning the
functionlists. 

Eric Howe
eric@pieinsky.ca
http://pieinsky.ca/

Re: Missing date_trunc docs

From
Bruce Momjian
Date:
On Fri, Jun  7, 2013 at 11:32:14AM -0700, Eric Howe wrote:
> In table 9-27 of the 9.2 docs:
>
>     http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
>
> There is an entry for date_trunc(text, timestamp) but no entry for date_trunc(text, interval). The full docs for
date_trunc:
>
>     http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
>
> do mention both the timestamp and interval forms of date_trunc but that's easy to miss if you're just scanning the
functionlists. 

Thanks for the report.  The attached patch has been applied and will
appear in PG 9.4.  Sorry for the delay.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +
Attachment