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.96) (envelope-from ) id 1vOHgY-000nIo-0g for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 15:44:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOHgW-00HYM9-2Y for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 15:44:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOHgW-00HYM1-1V for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 15:44:00 +0000 Received: from smtp-81.smtpout.orange.fr ([80.12.242.81] helo=smtp.smtpout.orange.fr) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOHgU-001ap5-0s for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 15:43:59 +0000 Received: from X250.home ([IPv6:2a01:cb14:316:8c00:506c:d588:c52a:af6e]) by smtp.orange.fr with ESMTPSA id OHgSvvRAHY01oOHgSvFKou; Wed, 26 Nov 2025 16:43:56 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wanadoo.fr; s=t20230301; t=1764171836; bh=zAcKqipO7N9RlXPaN+hC1jrbrj3UTg1gVEtBqge9q/w=; h=Date:From:To:Subject:Message-Id:Mime-Version; b=tedWHc9uqwVsOjLdsBFaIM1jZqGbi+cMGsJOZAjJHz6VsO4I2xqc2Mc9QQyIoI952 06oQ3aS3p8Jt1F88u7apSz3zmPtxz3+aRzfp/wEGW4ii3bYoOaq6OS+FsVIY6RWasN Ec3V4glOwhZmaCSOt+4pippWGJP8JU94w2qWuw+SpTemMc6rIqcAVuRqD9L3e0zFXJ +W7Z/qE1F9jca8Zb5Zk6NoYYiCYnMVGp1Ey7j55hVX3FTzfnPvH4rVZMnUW/zEvbTJ dGrdo7S0MVvPF3liOfaIJ3bz3PweIhtx0/0NlEEdjkQefzHPqM+VthG/sND8Nt/qBX r+MxydafH4Puw== X-ME-Helo: X250.home X-ME-Auth: dnYubGlzdHNAd2FuYWRvby5mcg== X-ME-Date: Wed, 26 Nov 2025 16:43:56 +0100 X-ME-IP: 2a01:cb14:316:8c00:506c:d588:c52a:af6e Date: Wed, 26 Nov 2025 16:43:56 +0100 From: Vincent Veyron To: Rich Shepard Cc: pgsql-general@lists.postgresql.org Subject: Re: Selecting all variations of job title in a list Message-Id: <20251126164356.9a3b7fc25d5118e28175f9a4@wanadoo.fr> In-Reply-To: <29ffee7e-40a8-f911-4419-24ba8558f5db@appl-ecosys.com> References: <20251126154844.e6e3d5c7f476cc966fc201f4@wanadoo.fr> <29ffee7e-40a8-f911-4419-24ba8558f5db@appl-ecosys.com> X-Mailer: Sylpheed 3.8.0beta1 (GTK+ 2.24.33; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 26 Nov 2025 07:10:16 -0800 (PST) Rich Shepard wrote: >=20 > Learning postgres regexp is at the top of my list. >=20 https://perldoc.perl.org/perlre Read the first few pages and you'll be good to go. --=20 Bien =E0 vous, Vincent Veyron=20 https://marica.fr/=20 Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et = des contrats