Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cLvV9-0000Ol-Tj for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Dec 2016 17:25:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cLvV9-0005gB-Gd for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Dec 2016 17:25:27 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cLvTp-0005a6-Ba for pgsql-bugs@postgresql.org; Tue, 27 Dec 2016 17:24:05 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cLvTn-0001PK-2S for pgsql-bugs@postgresql.org; Tue, 27 Dec 2016 17:24:04 +0000 MIME-Version: 1.0 Subject: BUG #14479: Casting non-constant values to INTERVAL DAY TO MINUTE doesn't truncate the seconds field To: pgsql-bugs@postgresql.org From: email@piotr-stefaniak.me Date: Tue, 27 Dec 2016 17:23:07 +0000 Message-ID: <20161227172307.10135.7747@wrigleys.postgresql.org> X-Pg-Spam-Score: -1.2 (-) Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ3OQpMb2dnZWQgYnk6ICAg ICAgICAgIFBpb3RyIFN0ZWZhbmlhawpFbWFpbCBhZGRyZXNzOiAgICAgIGVt YWlsQHBpb3RyLXN0ZWZhbmlhay5tZQpQb3N0Z3JlU1FMIHZlcnNpb246IDku NC4xMApPcGVyYXRpbmcgc3lzdGVtOiAgIEZyZWVCU0QsIHByb2JhYmx5IGly cmVsZXZhbnQKRGVzY3JpcHRpb246ICAgICAgICAKCiMgU0VMRUNUIHgueTo6 SU5URVJWQUwgREFZIFRPIE1JTlVURSwgKGludGVydmFsICcwMjo0NzoxNS4z NzU3MjEnKTo6SU5URVJWQUwKREFZIFRPIE1JTlVURSBGUk9NIChWQUxVRVMg KGludGVydmFsICcwMjo0NzoxNS4zNzU3MjEnKSkgeCAoeSk7DQogICAgICAg IHkgICAgICAgIHwgaW50ZXJ2YWwgDQotLS0tLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tDQogMDI6NDc6MTUuMzc1NzIxIHwgMDI6NDc6MDANCg0KSSBjaG9z ZSA5LjQuMTAgYXMgdGhlIHZlcnNpb24gaW4gdGhlIHdlYiBmb3JtIGJlY2F1 c2UgdGhhdCdzIHdoYXQgSSBoYXZlLApidXQgQW5kcmV3IEdpZXJ0aCBoYXMg c2FpZCB0aGF0IHRoaXMgaXMgdGhlIGJlaGF2aW9yIG9mIHZlcnNpb25zOiA5 LjIsIDkuMywKYW5kIDkuNCBidXQgbm90IHZlcnNpb25zIDkuMSwgOS41LCBh bmQgSEVBRC4KCgotLSAKU2VudCB2aWEgcGdzcWwtYnVncyBtYWlsaW5nIGxp c3QgKHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdl cyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3Fs Lm9yZy9tYWlscHJlZi9wZ3NxbC1idWdzCg==