Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ulq2n-0003MR-Jf for pgsql-docs@arkaria.postgresql.org; Mon, 10 Jun 2013 00:33:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ulq2n-0005ys-3i for pgsql-docs@arkaria.postgresql.org; Mon, 10 Jun 2013 00:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ul1Sc-0005Tn-8J for pgsql-docs@postgresql.org; Fri, 07 Jun 2013 18:32:26 +0000 Received: from cmta6.telus.net ([209.171.16.79]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ul1SU-00036A-Oi for pgsql-docs@postgresql.org; Fri, 07 Jun 2013 18:32:24 +0000 Received: from [192.168.1.66] ([75.156.76.36]) by cmta6.telus.net with TELUS id lWYF1l00E0mzSoj01WYG3c; Fri, 07 Jun 2013 12:32:17 -0600 X-Authority-Analysis: v=2.0 cv=AvEwKpBP c=1 sm=2 a=+GmJavd48wFCs8gVecWHDA==:17 a=kj9zAlcOel0A:10 a=3uZBIp8IBzMA:10 a=epTmVMiNAAAA:8 a=rP2HYFFmAAAA:8 a=fLyVRPxR2BZmhfKWEP0A:9 a=CjuIK1q_8ugA:10 a=dWPfqpDcqUEA:10 a=+GmJavd48wFCs8gVecWHDA==:117 X-Telus-Outbound-IP: 75.156.76.36 From: Eric Howe Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: Missing date_trunc docs Message-Id: <7CC1BD41-AB5C-4AE0-B469-18C165D5706B@pieinsky.ca> Date: Fri, 7 Jun 2013 11:32:14 -0700 To: pgsql-docs@postgresql.org Mime-Version: 1.0 (Mac OS X Mail 6.3 \(1503\)) X-Mailer: Apple Mail (2.1503) X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org In table 9-27 of the 9.2 docs: http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUN= CTIONS-DATETIME-TABLE There is an entry for date_trunc(text, timestamp) but no entry for date_tru= nc(text, interval). The full docs for date_trunc: http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUN= CTIONS-DATETIME-TRUNC do mention both the timestamp and interval forms of date_trunc but that's e= asy to miss if you're just scanning the function lists. Eric Howe eric@pieinsky.ca http://pieinsky.ca/ --=20 Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs