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 1nEh1J-0003wx-H5 for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Feb 2022 00:27:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEh1I-0007Xm-Bk for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Feb 2022 00:27:40 +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 1nEgcb-0004Fw-Lo for pgsql-bugs@lists.postgresql.org; Tue, 01 Feb 2022 00:02:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nEgcY-0001z9-H3 for pgsql-bugs@lists.postgresql.org; Tue, 01 Feb 2022 00:02:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=aw7YTeFCQ5LEd+Vp1kzp8fSZnFp3Ljd5COwJ9PiLN3s=; b=4EhuSU/dY8M8na0Z4BNCCpeS33 ksNT4jpYVgw4l+s4B9kD5iO53TiJQ/1t/VbTtD0a2OoXA5rrwTWGWs4S17olvQW+A838jTeuY94ch YCM6pMdZbaCbr4jGofly1YC22d0k3Rb2mqAmWoQsx5Ou8mQ8HTxd3+nhXl3nzI1rbrmRZ7T7AFcw6 HSQY6tiKYXOK2AncOI7B6xjJUob0jD7CCg3QT4h74Z3kOtFNYy5ktip9ejslRs7BmaIz1t8Obe8Zd 5LrFwipdNEJNdFW5cF7SBuWtv1diAD84ZdFn8Z0FlwA0lnX7pi3HQ2amoc5AMs8umbVodZ2gQKe/e NIBIGpdw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nEgcW-0000RS-Up for pgsql-bugs@lists.postgresql.org; Tue, 01 Feb 2022 00:02:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEgcU-0003kF-4u for pgsql-bugs@lists.postgresql.org; Tue, 01 Feb 2022 00:02:02 +0000 Content-Type: multipart/mixed; boundary="===============2884371966174994952==" MIME-Version: 1.0 Subject: BUG #17390: Function, to_date() -- unexpected values and a request To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: smk_va@yahoo.com Reply-To: smk_va@yahoo.com, pgsql-bugs@lists.postgresql.org Date: Tue, 01 Feb 2022 00:01:40 +0000 Message-ID: <17390-3aea53f5c03c0e4a@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2884371966174994952== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM5MApMb2dnZWQgYnk6ICAgICAgICAgIE11cnRoeSBLYW1iaGFtcGF0 eQpFbWFpbCBhZGRyZXNzOiAgICAgIHNta192YUB5YWhvby5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMC43Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cwpEZXNjcmlwdGlvbjogICAgICAgIAoK VGhlIHRvX2RhdGUoKSBmdW5jdGlvbiBzZWVtcyBub3QgdG8gZnVsbHkgdGVzdCBvdXQtb2YtcmFu Z2UgdmFsdWVzLiBBbgpleGFtcGxlIHF1ZXJ5IGFuZCBvdXRwdXQgYXJlIGxpc3RlZCBiZWxvdzoN Cg0KcG9zdGdyZXM9PiBzZWxlY3QgdG9fZGF0ZSgnMTk5OS0wMC0wMScsICdZWVlZIi0iTU0iLSJE RCcpDQogICAgICAgICwgdG9fZGF0ZSgnMTk5OS5NMDAnLCAnWVlZWSIuTSJNTScpDQpwb3N0Z3Jl cy0+IDsNCiAgdG9fZGF0ZSAgIHwgIHRvX2RhdGUNCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0N CiAxOTk5LTAxLTAxIHwgMTk5OS0wMS0wMQ0KKDEgcm93KQ0KKGFsc28gdGVzdGVkIHVuZGVyIHdp dGggMTMgYW5kIDE0KQ0KDQpPbiB0aGUgb3RoZXIgaGFuZCwgYSB0b28taGlnaCB2YWx1ZSBmb3Ig dGhlIG1vbnRoLCBzdWNoIGFzIDI1LCBkb2VzIHJlc3VsdAppbiB0aGUgZXhwZWN0ZWQgb3V0LW9m LXJhbmdlIGVycm9yLiBUaGUgYWJvdmUgc2VlbXMgYSBidWcuDQoNClRoZSByZXF1ZXN0IGhhcyB0 byBkbyB3aXRoIHByb2Nlc3Npbmcgb2YgcXVhcnRlcmx5IGRhdGVzIHVzaW5nIHRoZQonWVlZWSI6 USJxJyBmb3JtYXQgc3RyaW5nLCBhbmQgdGhlIGxpa2UuIFRoZSBkb2N1bWVudGF0aW9uIHByZXNl bnRseSBub3Rlcwp0aGF0LCAiSW4gdG9fdGltZXN0YW1wIGFuZCB0b19kYXRlLCB3ZWVrZGF5IG5h bWVzIG9yIG51bWJlcnMgKERBWSwgRCwgYW5kCnJlbGF0ZWQgZmllbGQgdHlwZXMpIGFyZSBhY2Nl cHRlZCBidXQgYXJlIGlnbm9yZWQgZm9yIHB1cnBvc2VzIG9mIGNvbXB1dGluZwp0aGUgcmVzdWx0 LiBUaGUgc2FtZSBpcyB0cnVlIGZvciBxdWFydGVyIChRKSBmaWVsZHMuIiBGaXJzdCwgaXQgaXMg ZWFzeSB0bwptaXNzIHRoaXMgaW4gdGhlIGRvY3VtZW50YXRpb24uIFNvIGEgIkNBVVRJT04iIG5v dGljZSwgYWJvdmUgdGhlICJUaXAiIHdvdWxkCmJlIGhlbHBmdWw7IHNvbWV0aGluZyB0byB0aGUg ZWZmZWN0IHRoYXQsICJ0b190aW1lc3RhbXAgYW5kIHRvX2RhdGUgZXhpc3QgdG8KaGFuZGxlIGlu cHV0IGZvcm1hdHMgdGhhdCBjYW5ub3QgYmUgY29udmVydGVkIGJ5IHNpbXBsZSBjYXN0aW5nLiBI b3dldmVyLApjZXJ0YWluIGlucHV0IGZvcm1hdCBzcGVjaWZpZXJzIGFyZSBpZ25vcmVkLCBhbmQg dGh1cyB0aGUgcmVzdWx0IG1heSBiZQp1bmV4cGVjdGVkLiINCg0KSSBzdWJtaXQsIGhvd2V2ZXIs IHRoYXQgcmV0dXJuaW5nICcxOTk5LTAxLTAxJyBpbiByZXNwb25zZSB0byBzZWxlY3QKdG9fZGF0 ZSgnMTk5OTpRMycsICdZWVlZIjpRInEnKSBpcyBidWdneSAtLSB0aGUgaW5wdXQgaXMgdW5hbWJp Z3VvdXMgaW4gdGhlCnNhbWUgc2Vuc2UgdGhhdCB0b19kYXRlKCcxOTk5Lk03JywgJ0ZYeXl5eSIu TSJtbScpIGlzLCBidXQgdGhlIG91dHB1dCBpcyBub3QKdGhlIHNhbWUgaW4gYm90aCBpbnN0YW5j ZXMhIFRodXMsIHRoZSBwcmVmZXJyZWQgYXBwcm9hY2ggaGVyZSwgSU1ITywgaXMgdG8KcmV0dXJu IGFuIGVycm9yIHdoZW4gdGhlIGZvcm1hdCBzdHJpbmcgaXMgYW1iaWd1b3VzLCBhbmQgdG8gcmV0 dXJuCmNvbnNpc3RlbnQgdmFsdWVzIHdoZW4gdGhlIGZvcm1hdCBpcyB1bmFtYmlndW91cywgd2l0 aCAiY29uc2lzdGVudCB2YWx1ZXMiCm9ic2VydmluZyB0aGUgc2FtZSBydWxlcyBhcyBpbiBtYWtl X2RhdGUoKSBhbmQgbWFrZV90aW1lc3RhbXAoKS4gVGh1cywgdGhlCidEREQnLXNwZWNpZmllciBp biAnWVlZWSItIkRERCcsIHdvdWxkICpub3QqIGJlIGlnbm9yZWQsIGFuZCB0aGUKJ1EnLXNwZWNp ZmllciBpbiAnWVlZWSI6USJRJyB3b3VsZCBhbHNvIG5vdCBiZSBpZ25vcmVkLCB3aGVyZWFzICdZ WVlZIi0iREQnCmFuZCAnWVlZWSItIkQiLCBhbmQgJ1lZWVkiLSJXVycgd291bGQgcmV0dXJuIGVy cm9ycyBmbGFnZ2luZyB0aGUgZm9ybWF0cyBhcwphbWJpZ3VvdXMgb3IgaW52YWxpZC4gKEl0IHdv dWxkIGFsc28gaGVscCB0byBoYXZlIGNsYXJpdHkgd2hldGhlciBhbnkgZm9ybWF0CnNwZWNpZmll cnMgb3RoZXIgdGhhbiAneXl5eScgYXJlIGNhc2UtaW5zZW5zaXRpdmUuKQ0KDQpJbiBteSBleHBl cmllbmNlLCBtb250aGx5LCBxdWFydGVybHksIGFuZCB3ZWVrbHkgZGF0ZXMgYXBwZWFyIGluIGdv dmVybm1lbnQKc3RhdGlzdGljcy4gKEkgaGF2ZSBkZXBsb3llZCBQb3N0Z3JlU1FMIGFzIHBhcnQg b2YgYSBkYXRhLWFuYWx5c2lzIHN0YWNrCnNpbmNlIHZlcnNpb24gNy4yIG9yIHNvLCBiZWNhdXNl IEkgZmluZCBpdCBzdXBlcmlvciB0byBtYW55IGFsdGVybmF0aXZlcwpiZWNhdXNlIFBvc3RncmVT UUwgcmV0dXJucyBlcnJvcnMgd2hlbiBmZWQgYW1iaWd1b3VzIG9yIG91dC1vZi1yYW5nZSBkYXRh IGluCmFuIEVUTCBwaXBlbGluZSwgcmF0aGVyIHRoYW4gc3RvcmluZyB1bmV4cGVjdGVkIHZhbHVl czsgdGhlIGFib3ZlCmluY29uc2lzdGVuY2llcyBpbiB0b19kYXRlKCkgcHJvY2Vzc2luZyBjYW1l IGFzIGEgbWlsZCBzaG9jay4pCgo= --===============2884371966174994952==--