Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pBno1-0001ae-Iv for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Jan 2023 02:10:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pBno0-0000ZZ-6I for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Jan 2023 02:10:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pBnnz-0000ZQ-TK for pgsql-hackers@lists.postgresql.org; Sun, 01 Jan 2023 02:10:31 +0000 Received: from relay1-d.mail.gandi.net ([2001:4b98:dc4:8::221]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pBnnv-0004Jr-BW for pgsql-hackers@lists.postgresql.org; Sun, 01 Jan 2023 02:10:31 +0000 Received: (Authenticated sender: vik@postgresfriends.org) by mail.gandi.net (Postfix) with ESMTPSA id 3273E240004; Sun, 1 Jan 2023 02:10:23 +0000 (UTC) Content-Type: multipart/mixed; boundary="------------BbtbJ3cx9W2g3R0VBjB1XM7g" Message-ID: Date: Sun, 1 Jan 2023 03:10:23 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 From: Vik Fearing Content-Language: en-US To: PostgreSQL Hackers Subject: +infinity for dates and timestamps Cc: jian he List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------BbtbJ3cx9W2g3R0VBjB1XM7g Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit It has always annoyed me that we can't write '+infinity' for dates and timestamps and get the OCD satisfaction of making our queries line up with '-infinity'. I wrote a fix for that some time ago but apparently never posted it. I was reminded of it by jian he in the Infinite Interval thread, and so here it is. -- Vik Fearing --------------BbtbJ3cx9W2g3R0VBjB1XM7g Content-Type: text/x-patch; charset=UTF-8; name="plus_infinity.diff" Content-Disposition: attachment; filename="plus_infinity.diff" Content-Transfer-Encoding: base64 Y29tbWl0IDUxNzhhMTdhMzI4MGJjMDAxODE5NGU1OTBkMWI5ZmIzYWZiZTNiNjUKQXV0aG9y OiBWaWsgRmVhcmluZyA8dmlrQHBvc3RncmVzZnJpZW5kcy5vcmc+CkRhdGU6ICAgVHVlIEp1 biA3IDAwOjIyOjIxIDIwMjIgKzAyMDAKCiAgICBhbGxvdyAraW5maW5pdHkgZm9yIGRhdGVz CgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwgYi9kb2Mvc3JjL3Nn bWwvZGF0YXR5cGUuc2dtbAppbmRleCBmZGZmYmE0NDQyLi44NjNhYjg0NDQyIDEwMDY0NAot LS0gYS9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZGF0 YXR5cGUuc2dtbApAQCAtMjI4OCw3ICsyMjg4LDcgQEAgVElNRVNUQU1QIFdJVEggVElNRSBa T05FICcyMDA0LTEwLTE5IDEwOjIzOjU0KzAyJwogICAgICAgPHByb2R1Y3RuYW1lPlBvc3Rn cmVTUUw8L3Byb2R1Y3RuYW1lPiBzdXBwb3J0cyBzZXZlcmFsCiAgICAgICBzcGVjaWFsIGRh dGUvdGltZSBpbnB1dCB2YWx1ZXMgZm9yIGNvbnZlbmllbmNlLCBhcyBzaG93biBpbiA8eHJl ZgogICAgICAgbGlua2VuZD0iZGF0YXR5cGUtZGF0ZXRpbWUtc3BlY2lhbC10YWJsZSIvPi4g IFRoZSB2YWx1ZXMKLSAgICAgIDxsaXRlcmFsPmluZmluaXR5PC9saXRlcmFsPiBhbmQgPGxp dGVyYWw+LWluZmluaXR5PC9saXRlcmFsPgorICAgICAgPGxpdGVyYWw+aW5maW5pdHk8L2xp dGVyYWw+IChhbHRlcm5hdGl2ZWx5IDxsaXRlcmFsPitpbmZpbml0eTwvbGl0ZXJhbD4pIGFu ZCA8bGl0ZXJhbD4taW5maW5pdHk8L2xpdGVyYWw+CiAgICAgICBhcmUgc3BlY2lhbGx5IHJl cHJlc2VudGVkIGluc2lkZSB0aGUgc3lzdGVtIGFuZCB3aWxsIGJlIGRpc3BsYXllZAogICAg ICAgdW5jaGFuZ2VkOyBidXQgdGhlIG90aGVycyBhcmUgc2ltcGx5IG5vdGF0aW9uYWwgc2hv cnRoYW5kcwogICAgICAgdGhhdCB3aWxsIGJlIGNvbnZlcnRlZCB0byBvcmRpbmFyeSBkYXRl L3RpbWUgdmFsdWVzIHdoZW4gcmVhZC4KQEAgLTIzMTUsNyArMjMxNSw3IEBAIFRJTUVTVEFN UCBXSVRIIFRJTUUgWk9ORSAnMjAwNC0xMC0xOSAxMDoyMzo1NCswMicKICAgICAgICAgICA8 ZW50cnk+MTk3MC0wMS0wMSAwMDowMDowMCswMCAoVW5peCBzeXN0ZW0gdGltZSB6ZXJvKTwv ZW50cnk+CiAgICAgICAgICA8L3Jvdz4KICAgICAgICAgIDxyb3c+Ci0gICAgICAgICAgPGVu dHJ5PjxsaXRlcmFsPmluZmluaXR5PC9saXRlcmFsPjwvZW50cnk+CisgICAgICAgICAgPGVu dHJ5PjxsaXRlcmFsPmluZmluaXR5PC9saXRlcmFsPiBvciA8bGl0ZXJhbD4raW5maW5pdHk8 L2xpdGVyYWw+PC9lbnRyeT4KICAgICAgICAgICA8ZW50cnk+PHR5cGU+ZGF0ZTwvdHlwZT4s IDx0eXBlPnRpbWVzdGFtcDwvdHlwZT48L2VudHJ5PgogICAgICAgICAgIDxlbnRyeT5sYXRl ciB0aGFuIGFsbCBvdGhlciB0aW1lIHN0YW1wczwvZW50cnk+CiAgICAgICAgICA8L3Jvdz4K ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9kYXRldGltZS5jIGIvc3JjL2Jh Y2tlbmQvdXRpbHMvYWR0L2RhdGV0aW1lLmMKaW5kZXggOGFmZGEwZTVkMi4uNmIyZGExYWNm ZSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2RhdGV0aW1lLmMKKysrIGIv c3JjL2JhY2tlbmQvdXRpbHMvYWR0L2RhdGV0aW1lLmMKQEAgLTEwNSw2ICsxMDUsNyBAQCBj b25zdCBjaGFyICpjb25zdCBkYXlzW10gPSB7IlN1bmRheSIsICJNb25kYXkiLCAiVHVlc2Rh eSIsICJXZWRuZXNkYXkiLAogICovCiBzdGF0aWMgY29uc3QgZGF0ZXRrbiBkYXRldGt0Ymxb XSA9IHsKIAkvKiB0b2tlbiwgdHlwZSwgdmFsdWUgKi8KKwl7TEFURTIsIFJFU0VSViwgRFRL X0xBVEV9LAkvKiAiK2luZmluaXR5IiByZXNlcnZlZCBmb3IgImxhdGUgdGltZSIgKi8KIAl7 RUFSTFksIFJFU0VSViwgRFRLX0VBUkxZfSwgLyogIi1pbmZpbml0eSIgcmVzZXJ2ZWQgZm9y ICJlYXJseSB0aW1lIiAqLwogCXtEQV9ELCBBREJDLCBBRH0sCQkJLyogImFkIiBmb3IgeWVh cnMgPiAwICovCiAJeyJhbGxiYWxscyIsIFJFU0VSViwgRFRLX1pVTFV9LCAvKiAwMDowMDow MCAqLwpkaWZmIC0tZ2l0IGEvc3JjL2luY2x1ZGUvdXRpbHMvZGF0ZXRpbWUuaCBiL3NyYy9p bmNsdWRlL3V0aWxzL2RhdGV0aW1lLmgKaW5kZXggYmRiN2MwNmJlYy4uZDUwM2Q4YjI0ZCAx MDA2NDQKLS0tIGEvc3JjL2luY2x1ZGUvdXRpbHMvZGF0ZXRpbWUuaAorKysgYi9zcmMvaW5j bHVkZS91dGlscy9kYXRldGltZS5oCkBAIC0zOCw2ICszOCw3IEBAIHN0cnVjdCB0ekVudHJ5 OwogI2RlZmluZSBJTlZBTElECQkJImludmFsaWQiCiAjZGVmaW5lIEVBUkxZCQkJIi1pbmZp bml0eSIKICNkZWZpbmUgTEFURQkJCSJpbmZpbml0eSIKKyNkZWZpbmUgTEFURTIJCQkiK2lu ZmluaXR5IgogI2RlZmluZSBOT1cJCQkJIm5vdyIKICNkZWZpbmUgVE9EQVkJCQkidG9kYXki CiAjZGVmaW5lIFRPTU9SUk9XCQkidG9tb3Jyb3ciCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9y ZWdyZXNzL3NxbC9kYXRlLnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2RhdGUuc3FsCmlu ZGV4IDlmZDE1YmU1ZjkuLjFkY2IwN2I3OGYgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL2RhdGUuc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2RhdGUuc3FsCkBA IC0zMjksNiArMzI5LDcgQEAgc2VsZWN0ICdpbmZpbml0eSc6OmRhdGUsICctaW5maW5pdHkn OjpkYXRlOwogc2VsZWN0ICdpbmZpbml0eSc6OmRhdGUgPiAndG9kYXknOjpkYXRlIGFzIHQ7 CiBzZWxlY3QgJy1pbmZpbml0eSc6OmRhdGUgPCAndG9kYXknOjpkYXRlIGFzIHQ7CiBzZWxl Y3QgaXNmaW5pdGUoJ2luZmluaXR5Jzo6ZGF0ZSksIGlzZmluaXRlKCctaW5maW5pdHknOjpk YXRlKSwgaXNmaW5pdGUoJ3RvZGF5Jzo6ZGF0ZSk7CitzZWxlY3QgJ2luZmluaXR5Jzo6ZGF0 ZSA9ICcraW5maW5pdHknOjpkYXRlIGFzIHQ7CiAtLQogLS0gb3NjaWxsYXRpbmcgZmllbGRz IGZyb20gbm9uLWZpbml0ZSBkYXRlOgogLS0KZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3RpbWVzdGFtcC5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC90aW1lc3RhbXAu c3FsCmluZGV4IGUxMTc1YjEyY2UuLjAwNGQxZDM0NTQgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3RpbWVzdGFtcC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwv dGltZXN0YW1wLnNxbApAQCAtNDksNiArNDksMTAgQEAgSU5TRVJUIElOVE8gVElNRVNUQU1Q X1RCTCBWQUxVRVMgKCctaW5maW5pdHknKTsKIElOU0VSVCBJTlRPIFRJTUVTVEFNUF9UQkwg VkFMVUVTICgnaW5maW5pdHknKTsKIElOU0VSVCBJTlRPIFRJTUVTVEFNUF9UQkwgVkFMVUVT ICgnZXBvY2gnKTsKIAorLS0gTWFrZSBzdXJlICdpbmZpbml0eScgYW5kICcraW5maW5pdHkn IGFyZSB0aGUgc2FtZQorU0VMRUNUIHRpbWVzdGFtcCAnaW5maW5pdHknID0gdGltZXN0YW1w ICcraW5maW5pdHknIEFTIHQ7CitTRUxFQ1QgdGltZXN0YW1wdHogJ2luZmluaXR5JyA9IHRp bWVzdGFtcHR6ICcraW5maW5pdHknIEFTIHQ7CisKIC0tIFBvc3RncmVzIHY2LjAgc3RhbmRh cmQgb3V0cHV0IGZvcm1hdAogSU5TRVJUIElOVE8gVElNRVNUQU1QX1RCTCBWQUxVRVMgKCdN b24gRmViIDEwIDE3OjMyOjAxIDE5OTcgUFNUJyk7CiAK --------------BbtbJ3cx9W2g3R0VBjB1XM7g--