Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXGLI-005nZ3-Bp for pgsql-general@arkaria.postgresql.org; Sat, 19 Aug 2023 07:25:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qXGLF-00FkPt-Lk for pgsql-general@arkaria.postgresql.org; Sat, 19 Aug 2023 07:25:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from <77M1C@gmx.com>) id 1qXGLF-00FkPk-94 for pgsql-general@lists.postgresql.org; Sat, 19 Aug 2023 07:25:49 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from <77M1C@gmx.com>) id 1qXGL4-0010NS-DN for pgsql-general@lists.postgresql.org; Sat, 19 Aug 2023 07:25:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.com; s=s31663417; t=1692429935; x=1693034735; i=77m1c@gmx.com; bh=UXf5bg3Cut9/TyVmneb+jC/HQQ23N4VuJZQv6kbsI2g=; h=X-UI-Sender-Class:Date:To:From:Subject; b=lzO4UkuLtBRTnHoHAJnzOBcdrjeUPUcibhI9lK+5OgKLVW90tzTbckhIp1TNE8rl7BNHM5B h1JqSwI0+Xj7Dxh8HgPUISPerDhzBKpMIqXSw93WyBnGDdFs/p0eLVNHc4dwH0lfA87T+X+ZZ EKRCX3JQLMdApDCpKfBEN9HBqTPRJpMe/W6mhkteqQhJWZvlBQJWaK7yVx7vtjO5acUdwxyOq u1eSwFgCHfUJLKNqgcii4CcvSyZWhgDe3rfvaIIZ6Y0kdqJqZG5vWhalNVjyMufkrQgl6QgFG xFEQd7+VeKIE6TralxfM+cZJD7riNjJXL3/2UYfrD28DpLS03nRA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.80.2] ([81.164.14.80]) by mail.gmx.net (mrgmx105 [212.227.17.174]) with ESMTPSA (Nemesis) id 1N7iCg-1pcfL31SR0-014jg2 for ; Sat, 19 Aug 2023 09:25:35 +0200 Message-ID: Date: Sat, 19 Aug 2023 09:25:29 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.1.2 Content-Language: en-US To: pgsql-general@lists.postgresql.org From: M4X <77M1C@gmx.com> Subject: case and accent insensitive search under Python ? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:wpOPOrrbzfBZLILWpgmkCCOgnlrpdlxiV1595XXAYgNDlIzY1Eq /JB2FImaHjmUxMD2RVOHuYgjmry+mQGCQK3H8fGiZM450jZPNG+xM0pYahDcxvf2ojW+ZJL p6BHVPY1Rf/eicGY4y1quf/plMBu03rY/hY7MKgiWFPp0hei2CljxHLz2MIp/osSerC0+KH qcpLs2HvT2HnUy7KCf3iA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:pjP26dDaMfI=;efxI2hQNc0h+VYJ+q8iQPZV3SOx c3EtMvOQWIyaXpDszFRhFTdOlnGSEspxJIzZOykUGRN2cQcuSm3aJ0k5DudRTeEp30BwFatEK 8GGLTdxmk41kwwcWpPvo9bK7xsQAM8t7Y/gsTuIW7aEbViZeg+XsAifXS3Q1MJ/9ezQ96IOFE 1Wmltdoo/LCwt2yRPV03unuirFbzU9U0EhU269Y7UEbem1oJDai5Cn6wAi6fd7CjTyIxhdFyB PyQViguCVx5WcwaLYvs+uli9pg74o/tSFbiPjN6pigFUooFzG4lZLDg5snaH7cnFEenZYpGpw sOJ1zwFjl2mPaq1WZSnYMxChjPiGgEWxydf2Fn1Jiumq6gjGZLdk/PizEpaiZqKS6xPwyT4Fk OOdo4KYSe+fMFkjb9wFW2ne47/pQO0ART34EeD+wwrYYrw8t8L7Wuhe3ChP567TG8uRcNlb7x sD87TVZ/bpP15RrrTFJsIRPoDHugEZm08lS70nUOP/Quv1PQTJ7xoNdv3tsgEua3F+qzo9q6y QX6Qpf3sVhcKqQXaHnU4eA+0RMr6wasDSNkLlM06IMxW27iX5greGWL0CtkQWhDMSkR78eq8k FaQqweDD/CbkQqc0YelAXmQgzct1dg43ItxNSscmuICnTB+Me/hbpMGAxxMV8NfTl3Ofv7oSB kIiO7xJ5UNOirEIphkS7rAU1wxhrp/XU20FBswRBhIxOrCKSzBSr9xT5GXp4RSu0GOKZkix4s ChFkqyY2L7FVTZ6hcVUhrNwI8mv3JsKg5utYmlwkgV8RkItBl+5WMcNcD8VdRnzQQVU4/+5nT Cyc9X2hQWUDG9AmbB8Y1pYVVknR2Uca6+pOURtRtZXtKx+e5oHjNmbjgFN9AtaA4ggp6JKMUH FiupBdzqKw+mC/+T31MmgzhXVtn6wVc/zgd/ne6annv5MVffUwj9B96RiCZInd8nKDZgrdMo/ sKCF0EDCc8SkGokOcpK7QONdfrA= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I'm considering to migrate to postgresql... ( still examining the pro/con = ) It seem that is possible to make a search that is case and accent insensitive. |I've dig https://www.postgresql.org/docs/current/textsearch-intro.html and other resources,| |but I didn't find yet an example that demonstrate it. (from Python would be even better :) ) Just to see if it's easy to implement. | |Thanks.| |Max | | |