Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dMsBt-0004Wj-OO for pgsql-sql@arkaria.postgresql.org; Mon, 19 Jun 2017 08:37:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dMsBt-0006Pd-5C for pgsql-sql@arkaria.postgresql.org; Mon, 19 Jun 2017 08:37:45 +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.84_2) (envelope-from ) id 1dMsBr-0006NG-CO; Mon, 19 Jun 2017 08:37:43 +0000 Received: from forward4h.cmail.yandex.net ([2a02:6b8:0:f35::111]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dMsBn-0005y1-NM; Mon, 19 Jun 2017 08:37:42 +0000 Received: from mxback2o.mail.yandex.net (mxback2o.mail.yandex.net [IPv6:2a02:6b8:0:1a2d::1c]) by forward4h.cmail.yandex.net (Yandex) with ESMTP id AF4D2209A0; Mon, 19 Jun 2017 11:37:35 +0300 (MSK) Received: from web44g.yandex.ru (web44g.yandex.ru [95.108.252.214]) by mxback2o.mail.yandex.net (nwsmtp/Yandex) with ESMTP id dDuYPlFOfp-bYSqqv02; Mon, 19 Jun 2017 11:37:35 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1497861455; bh=2l9eQaNl/WREXnUk+WuMDMUQHcvPz8ajw01JrXCWu5Q=; h=From:To:Cc:In-Reply-To:References:Subject:Message-Id:Date; b=cHaC90bmTv40hkg0YvB9j+ke31q/OYt/6hqOqQMwbEt6+ONx1oJLizmMLCNAdlLAh c5mA8cnAzDwCI5Qo7GhEOwwNcMXAQpbf99tQYptGuozNbWVmLGKq2TbOo19SatZsVM AfQ2Y7lcEPQG7h2XiO///PxD+hWRlajtO1W0TAtI= Authentication-Results: mxback2o.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web44g.yandex.ru with HTTP; Mon, 19 Jun 2017 11:37:34 +0300 From: Samed YILDIRIM To: Saiful Muhajir , vinny Cc: "pgsql-sql@postgresql.org" , "pgsql-sql-owner@postgresql.org" In-Reply-To: References: Subject: Re: Find rows with "timestamp out of range" MIME-Version: 1.0 Message-Id: <138161497861454@web44g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Mon, 19 Jun 2017 11:37:34 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org PGRpdj5IaSBTYWlmdWwsPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+V2hpY2ggdmVyc2lvbiBvZiBQ b3N0Z3JlU1FMIGRvIHlvdSB1c2U/PC9kaXY+PGRpdj5IYXZlIHlvdSBldmVyIHVwZ3JhZGUgeW91 ciBQb3N0Z3JlcyBmcm9tIGVhcmxpZXIgbWFqb3IgcmVsZWFzZXM/PC9kaXY+PGRpdj5XaGF0IHdh cyB5b3VyIHVwZ3JhZGUgbWV0aG9kIChkdW1wL3Jlc3RvcmUsIHBnX3VwZ3JhZGUpPzwvZGl2Pjxk aXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7EsHlp IMOnYWzEscWfbWFsYXIuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2PjxkaXY+wqA8L2Rp dj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MTkuMDYuMjAxNywgMTA6NTksICJTYWlm dWwgTXVoYWppciIgJmx0O3NhaWZ1bG11aGFqaXJAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2tx dW90ZSB0eXBlPSJjaXRlIj48ZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLGhlbHZl dGljYSxzYW5zLXNlcmlmOyI+WWVzLCBJIGFtIHN1cmUuPC9kaXY+PGRpdiBzdHlsZT0iZm9udC1m YW1pbHk6YXJpYWwsaGVsdmV0aWNhLHNhbnMtc2VyaWY7Ij7CoDwvZGl2PjxkaXYgc3R5bGU9ImZv bnQtZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmOyI+wqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgIFRhYmxlICJwdWJsaWMuY29tbWVudHMiPGJyIC8+wqDCoMKgwqAgQ29s dW1uwqDCoMKgwqDCoCDilILCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIFR5cGXCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqAg4pSCwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoCBNb2RpZmllcnPCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoDxiciAv PuKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgDxiciAvPsKgY29t bWVudF9pZMKgwqDCoMKgwqAg4pSCIGJpZ2ludMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoCDilIIgbm90IG51bGwgZGVmYXVsdCBuZXh0dmFsKCdjb21tZW50c19jb21t ZW50X2lkX3NlcSc6OnJlZ2NsYXNzKTxiciAvPsKgdXNlcl9pZMKgwqDCoMKgwqDCoMKgwqAg4pSC IGJpZ2ludMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCDilIIgbm90 IG51bGw8YnIgLz7CoHN0YXR1c8KgwqDCoMKgwqDCoMKgwqDCoCDilIIgc21hbGxpbnTCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCDilIIgbm90IG51bGwgZGVmYXVsdCAxPGJy IC8+wqBtZXNzYWdlwqDCoMKgwqDCoMKgwqDCoCDilIIgdGV4dMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAg4pSCIG5vdCBudWxsPGJyIC8+wqBjcmVhdGVfdGlt ZcKgwqDCoMKgIOKUgiB0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpvbmUg4pSCIG5vdCBudWxsIGRl ZmF1bHQgbm93KCk8YnIgLz7CoHVwZGF0ZV90aW1lwqDCoMKgwqAg4pSCIHRpbWVzdGFtcCB3aXRo b3V0IHRpbWUgem9uZSDilII8L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxoZWx2 ZXRpY2Esc2Fucy1zZXJpZjsiPsKgPC9kaXY+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWws aGVsdmV0aWNhLHNhbnMtc2VyaWY7Ij7CoDwvZGl2PjwvZGl2PjxkaXY+wqA8ZGl2PjxkaXY+PGRp dj48ZGl2PjxkaXY+PGRpdj48Zm9udCBjb2xvcj0iIzY2NjY2NiIgc2l6ZT0iMiIgZmFjZT0idGFo b21hLCBzYW5zLXNlcmlmIj4tLTwvZm9udD48L2Rpdj48Zm9udCBjb2xvcj0iIzY2NjY2NiIgc2l6 ZT0iMiIgZmFjZT0idGFob21hLCBzYW5zLXNlcmlmIj5SZWdhcmRzLDxiciAvPjxiciAvPjxhIHRh cmdldD0iX2JsYW5rIiBocmVmPSJodHRwOi8vc2FpZnVsbXVoYWppci53ZWIuaWQvIj5TYWlmdWwg TXVoYWppcjwvYT48L2ZvbnQ+PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+wqA8ZGl2Pk9u IDE5IEp1bmUgMjAxNyBhdCAxNDo1NCwgdmlubnkgPHNwYW4+Jmx0OzxhIHRhcmdldD0iX2JsYW5r IiBocmVmPSJtYWlsdG86dmlubnlAeHM0YWxsLm5sIj52aW5ueUB4czRhbGwubmw8L2E+Jmd0Ozwv c3Bhbj4gd3JvdGU6PGJsb2NrcXVvdGUgc3R5bGU9Im1hcmdpbjowIDAgMCAwLjhleDtib3JkZXIt bGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4OyI+PHNwYW4+T24gPHNwYW4+MjAx Ny0wNi0xOSAwOTwvc3Bhbj46MTEsIFNhaWZ1bCBNdWhhamlyIHdyb3RlOjwvc3Bhbj48YmxvY2tx dW90ZSBzdHlsZT0ibWFyZ2luOjAgMCAwIDAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlk O3BhZGRpbmctbGVmdDoxZXg7Ij5IaSw8YnIgLz48YnIgLz5JIGhhdmUgYSB0YWJsZSB3aXRoIGFy b3VuZCAxMzMgTUlMTElPTiBST1dTIHdpdGggdHdvIHRpbWVzdGFtcDxiciAvPjxzcGFuPmNvbHVt bnMuIFdoaWxlIHRyeWluZyB0byBjb3B5IHNvbWUgY29sdW1ucyBmb3IgYSBuZXcgZGF0YWJhc2Us IHVzaW5nPC9zcGFuPjxiciAvPlxDT1BZICwgdGhlIGVycm9yIG9jY3VycmVkIHdpdGg6IFRJTUVT VEFNUCBPVVQgT0YgUkFOR0U8YnIgLz48c3Bhbj7igItXaGlsZSB0cnlpbmcgdG/igIsgZmlndXJl IG91dCB0aGUgcm93cyBjb250YWluaW5nIHRoZSBvdXQgb2YgcmFuZ2U8YnIgLz52YWx1ZSwgSSBh bSB1c2luZyB0aGlzIHdpdGggbm8gcmVzdWx0Ojwvc3Bhbj48YnIgLz7CoDwvYmxvY2txdW90ZT48 YnIgLz5BcmUgeW91IHN1cmUgdGhhdCBDUkVBVEVEX0FUIGlzIGEgdGltZXN0YW1wPyBJdCBzZWVt cyBvZGQgdGhhdDxiciAvPnRoZSBkYXRhYmFzZSB3b3VsZCBjb250YWluIGFuIGludmFsaWQgdGlt ZXN0YW1wIHZhbHVlIGluIGEgdGltZXN0YW1wIGZpZWxkLjwvYmxvY2txdW90ZT48L2Rpdj48L2Rp dj48L2Jsb2NrcXVvdGU+