Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inNBF-0001S8-QK for pgsql-docs@arkaria.postgresql.org; Fri, 03 Jan 2020 13:39:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1inNBE-0003eO-GE for pgsql-docs@arkaria.postgresql.org; Fri, 03 Jan 2020 13:39:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inM7c-0001mJ-DE for pgsql-docs@lists.postgresql.org; Fri, 03 Jan 2020 12:32:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1inM7Y-00036m-UU for pgsql-docs@lists.postgresql.org; Fri, 03 Jan 2020 12:32:08 +0000 Content-Type: multipart/mixed; boundary="===============1670086256829194933==" MIME-Version: 1.0 Subject: Argument 'week' not supported in date_trunc function with intervals To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: caetanosauer@gmail.com Reply-To: caetanosauer@gmail.com, pgsql-docs@lists.postgresql.org Date: Fri, 03 Jan 2020 12:31:27 +0000 Message-ID: <157805468778.1149.10815835689820301977@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1670086256829194933== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9mdW5j dGlvbnMtZGF0ZXRpbWUuaHRtbApEZXNjcmlwdGlvbjoKCkluIHRoZSBkb2N1bWVudGF0aW9uIG9m IHRoZSBkYXRlX3RydW5jIGZ1bmN0aW9uICg5LjkuMiksIHRoZSBmaXJzdCBhcmd1bWVudAooZmll bGQpIGNhbm5vdCBiZSAnd2VlaycgaWYgdGhlIHNlY29uZCBhcmd1bWVudCAoc291cmNlKSBpcyBh biBpbnRlcnZhbDoNCg0KY3NhdWVyPSMgU0VMRUNUIERBVEVfVFJVTkMoJ3dlZWsnLCBJTlRFUlZB TCAnNyBkYXlzJyk7ICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIA0KRVJST1I6ICBpbnRlcnZhbCB1bml0cyAid2VlayIgbm90IHN1cHBvcnRl ZCBiZWNhdXNlIG1vbnRocyB1c3VhbGx5IGhhdmUKZnJhY3Rpb25hbCB3ZWVrcw0KY3NhdWVyPSMg U0VMRUNUIERBVEVfVFJVTkMoJ3dlZWsnLCBJTlRFUlZBTCAnMSB3ZWVrJyk7ICAgICAgICAgICAg ICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQpFUlJPUjogIGlu dGVydmFsIHVuaXRzICJ3ZWVrIiBub3Qgc3VwcG9ydGVkIGJlY2F1c2UgbW9udGhzIHVzdWFsbHkg aGF2ZQpmcmFjdGlvbmFsIHdlZWtzDQoNClRoZSBkb2N1bWVudGF0aW9uIHNob3VsZCBzdGF0ZSB0 aGF0IGV4cGxpY2l0bHkuDQoNCkkgYWxzbyB0aGluayB0aGUgZXJyb3IgbWVzc2FnZSBjb3VsZCBi ZSBpbXByb3ZlZCwgYmVjYXVzZSBpbiB0aGUgY2FzZXMgYWJvdmUKdGhlcmUgYXJlIG5vIG1vbnRo cyBpbnZvbHZlZCBhbmQgdGhlIHJlc3VsdCBzaG91bGQgYmUgMS4K --===============1670086256829194933==--