Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fWvmN-0002si-14 for pgsql-docs@arkaria.postgresql.org; Sun, 24 Jun 2018 03:33:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fWvmL-0004ST-9z for pgsql-docs@arkaria.postgresql.org; Sun, 24 Jun 2018 03:33:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fWvmL-0004SL-1M for pgsql-docs@lists.postgresql.org; Sun, 24 Jun 2018 03:33:29 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fWvmG-0005mU-DW for pgsql-docs@lists.postgresql.org; Sun, 24 Jun 2018 03:33:27 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1fWvmF-0002HK-Jj; Sat, 23 Jun 2018 23:33:23 -0400 Date: Sat, 23 Jun 2018 23:33:23 -0400 From: Bruce Momjian To: Vladimir Svedov Cc: pgsql-docs@lists.postgresql.org Subject: Re: DATE_PART('field', INTERVAL) not intuitive literal reading of interval Message-ID: <20180624033323.GH2830@momjian.us> References: <152698651482.26744.15456677499485530703@wrigleys.postgresql.org> <20180620035839.GA32746@momjian.us> <20180620121217.GA7038@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Jun 20, 2018 at 03:42:54PM +0300, Vladimir Svedov wrote: > Yes, it covers my question great. Thank you  Patch applied back through 9.3. Thanks for the feedback. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +