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 1pkVfK-0002nr-Tc for pgsql-committers@arkaria.postgresql.org; Thu, 06 Apr 2023 19:53:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkVfJ-0004gt-OI for pgsql-committers@arkaria.postgresql.org; Thu, 06 Apr 2023 19:53:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkVfJ-0004SD-Fr for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:53:01 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkVfE-0004DF-RE for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:53:00 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkVfE-0003SM-0X for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:52:56 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pkVfC-001jBz-3P for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:52:55 +0000 Content-Type: multipart/mixed; boundary="===============8501668381715213555==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix ts_headline() edge cases for empty query and empty search te X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 06 Apr 2023 19:52:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8501668381715213555== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHRzX2hlYWRsaW5lKCkgZWRnZSBjYXNlcyBmb3IgZW1wdHkgcXVlcnkgYW5kIGVtcHR5IHNl YXJjaCB0ZXh0LgoKdHNxdWVyeSdzIEdFVFFVRVJZKCkgbWFjcm8gaXMgb25seSBzYWZlIHRvIGFw cGx5IHRvIGEgdHNxdWVyeQp0aGF0IGlzIGtub3duIG5vbi1lbXB0eTsgb3RoZXJ3aXNlIGl0IGdp dmVzIGEgcG9pbnRlciB0byBnYXJiYWdlLgpCZWZvcmUgY29tbWl0IDVhNjE3ZDc1ZCwgdHNfaGVh ZGxpbmUoKSBhdm9pZGVkIHRoaXMgcGl0ZmFsbCwgYnV0Cm9ubHkgaW4gYSB2ZXJ5IGluZGlyZWN0 LCBub25vYnZpb3VzIHdheS4gIChobENvdmVyIGNvdWxkIG5vdCByZWFjaAppdHMgVFNfZXhlY3V0 ZSBjYWxsLCBiZWNhdXNlIGlmIHRoZSBxdWVyeSBjb250YWlucyBubyBsZXhlbWVzCnRoZW4gaGxG aXJzdEluZGV4IHdvdWxkIHN1cmVseSByZXR1cm4gLTEuKSAgQWZ0ZXIgdGhhdCBjb21taXQsCml0 IGZlbGwgaW50byB0aGUgdHJhcCwgcmVzdWx0aW5nIGluIHdlaXJkIGVycm9ycyBzdWNoIGFzCiJ1 bnJlY29nbml6ZWQgb3BlcmF0b3IiIGFuZC9vciB2YWxncmluZCBjb21wbGFpbnRzLiAgSW4gSEVB RCwKZml4IHRoaXMgYnkgbm90IGNhbGxpbmcgVFNfZXhlY3V0ZV9sb2NhdGlvbnMoKSBhdCBhbGwg Zm9yIGFuCmVtcHR5IHF1ZXJ5LiAgSW4gdGhlIGJhY2sgYnJhbmNoZXMsIGFkZCBhIGRlZmVuc2l2 ZSBjaGVjayB0bwpobENvdmVyKCkgLS0tIHRoYXQncyBub3QgZml4aW5nIGFueSBsaXZlIGJ1Zywg YnV0IEkganVkZ2UgdGhlCmNvZGUgYSBiaXQgdG9vIGZyYWdpbGUgYXMtaXMuCgpBbHNvLCBib3Ro IG1hcmtfaGxfZnJhZ21lbnRzKCkgYW5kIG1hcmtfaGxfd29yZHMoKSB3ZXJlIGNhcmVsZXNzCmFi b3V0IHRoZSBwb3NzaWJpbGl0eSBvZiBlbXB0eSBzZWFyY2ggdGV4dDogaW4gdGhlIGNhc2VzIHdo ZXJlCm5vIG1hdGNoIGhhcyBiZWVuIGZvdW5kLCB0aGV5J2QgZW5kIHVwIHRlbGxpbmcgbWFya19m cmFnbWVudCgpIHRvCm1hcmsgZnJvbSB3b3JkIGluZGV4ZXMgMCB0byAwIGluY2x1c2l2ZSwgZXZl biB3aGVuIHRoZXJlIGlzIG5vCndvcmQgMC4gIFRoaXMgaXMgaGFybWxlc3Mgc2luY2Ugd2Ugb3Zl ci1hbGxvY2F0ZWQgdGhlIHBycy0+d29yZHMKYXJyYXksIGJ1dCBpdCBkb2VzIGFubm95IHZhbGdy aW5kLiAgRml4IHNvIHRoYXQgdGhlIGVuZCBpbmRleCBpcyAtMQphbmQgdGh1cyBtYXJrX2ZyYWdt ZW50KCkgd2lsbCBkbyBub3RoaW5nIGluIHN1Y2ggY2FzZXMuCgpCb3R0b20gbGluZSBpcyB0aGF0 IHRoaXMgZml4ZXMgYSBsaXZlIGJ1ZyBpbiBIRUFELCBidXQgaW4gdGhlCmJhY2sgYnJhbmNoZXMg aXQncyBvbmx5IGdldHRpbmcgcmlkIG9mIGEgdmFsZ3JpbmQgbml0cGljay4KQmFjay1wYXRjaCBh bnl3YXkuCgpQZXIgcmVwb3J0IGZyb20gQWxleGFuZGVyIExha2hpbi4KCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vYzI3ZjY0MmQtMDIwYi0wMWZmLWFlNjEtMDg2YWYyODdjNGZkQGdt YWlsLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mOTc2YTc3Nzg3ZWJmZDA1OTVh M2FhMTlhYzZiYjU4N2NjNjM5MWUyCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC90c2VhcmNoL3dwYXJzZXJfZGVmLmMgICAgIHwgIDggKysrKysrLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC90c2VhcmNoLm91dCB8IDIxICsrKysrKysrKysrKysrKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90c2VhcmNoLnNxbCAgICAgIHwgIDYgKysrKysrCjMgZmlsZXMg Y2hhbmdlZCwgMzMgaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============8501668381715213555==--