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 1vO0O3-005Xj3-1z for pgsql-general@arkaria.postgresql.org; Tue, 25 Nov 2025 21:15:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vO0O1-00Bp2w-2k for pgsql-general@arkaria.postgresql.org; Tue, 25 Nov 2025 21:15:46 +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 1vO0O1-00Bp2n-1e for pgsql-general@lists.postgresql.org; Tue, 25 Nov 2025 21:15:45 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vO0Nt-001SQd-39 for pgsql-general@lists.postgresql.org; Tue, 25 Nov 2025 21:15:43 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-656bb297e31so1018193eaf.0 for ; Tue, 25 Nov 2025 13:15:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764105338; x=1764710138; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=moX+yVE1Pl9JRL/oRQBUbnVZxoB2+uLP6wOs24nULgQ=; b=PyQgO6+n9B9zFqq1sjkLo7lGcLJGJEH7+R61+4fRTpN8NKMucSrdFW9uLUC9tA9Ahv jdSEGjHRParZBlEeraQyA3c9d3rXNkxxLZ4MWxyXNUM2VLuQKLeD8MJLtQK5jVanZLKX XLxL0PYB5BJwNMjnS6OxLFkMiih0IKRezYbQw9LEuZoY2kQpFLSHRhIM9iKsyPKrk7vY nj33vNgFm7iDhwt3KRP8kcCBJFiEpffzh6Jf35a3LhpL6miMldNna2dGBezeacA50FNJ uimGX+z/lZ8CkPff1Nih8CohTcUNITrjbjHAggcYtlC5dSc3FAOMp+NjTPjjIwx4ZEeB u/+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764105338; x=1764710138; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=moX+yVE1Pl9JRL/oRQBUbnVZxoB2+uLP6wOs24nULgQ=; b=MpL5+qXy0agVGTFiIry6G2H++RdWwyUQFjBnFcf2qBIHksVpCw+pz39uWF7wuxDTFH gFQ6Bm7mpurLyLGTFqvfIjocEFomRKzzZ4nH/3Qf3YHb+utgNfOvgyiD6JUPIqT3Rd9b mQnXwHunIEdxTgJrflD+M3TUNYplifct2KX4lgminFlJJzFNsBS9NKSOJy/tmpRpSlL3 qp0eDJfiA+K8dgxM0zBIXmZ3WdFzbo05J1Ds5XS68u3d6ZT9V9ycfhP96jFcU6oLplKa rv6E9Q9s6aPYvaqBS7gMDkrY38tQsaw4ANSr0PmMEpVdaF4i3iCH9zXRpbU3N3zbDk2Q pT3A== X-Gm-Message-State: AOJu0YyQ2Qg/+oLSm5RfqRwE8I5loq2TtcEMhGqhV2i+57nYhRRJO8IJ s3I5sFvkPxSDC5D9N7JdcxWLg0hs3WX68kLA65mwV/KizRsCGZkEzCAviGWfEXy/WkDxcygRLzh LKUc38nP54KMJBQGtNwSmWR+nH0XUnEg= X-Gm-Gg: ASbGncsIvn/eZBb/Ka+Lw1tuCaG1Owhfb2wCOOlagOeqi1toWDf5Ck97/npPJdCEuUj WThp4dnk5sEALJfOolBuLnTmF7/hiYnMhZ7QBEwJDATiacboth139bO02MDHnvxpHZZUkmbpZN+ p1T6ue3PqHICaS8Vu3iJ8rClue4AFpK6gqeeuZMDkuPV3QxyqqffKvaJwvo+8RBPqpNT5Q60evc WB28HYjS7cSQUsS/xZ8OElz67dMP3Fqvlzj8R2p/5K24ObQysNUvgw/08zp8c+3Nil2LII= X-Google-Smtp-Source: AGHT+IE5MD/sodLhthdmGcE9YWOjK04uJGnwiU4m5H71bS1NiMJKwiM/W5Zqg72xzNHViuoAosFty67/OE03S1vmavk= X-Received: by 2002:a05:6820:6ac1:b0:656:735e:9eff with SMTP id 006d021491bc7-65790bd8434mr5969413eaf.7.1764105337975; Tue, 25 Nov 2025 13:15:37 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:4d98:10b0:606:223e:1630 with HTTP; Tue, 25 Nov 2025 13:15:36 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 25 Nov 2025 14:15:36 -0700 X-Gm-Features: AWmQ_bmkrgNwlIGoxMWiqXoEmmUxfvrD1FLLd7jq3M0dlm2XL_6oRYJ_K2X-TdE Message-ID: Subject: Re: Selecting all variations of job title in a list To: Rich Shepard Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000436f9064471c87a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000436f9064471c87a Content-Type: text/plain; charset="UTF-8" On Tuesday, November 25, 2025, Rich Shepard wrote: > Companies can have slightly different titles for the same job; for example > (using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,', > 'Plant Mgr.' > Suggest encoding that knowledge in a table then using normal joins and filters to query against whatever you;ve decided is the canonical spelling of the relevant position. David J. --0000000000000436f9064471c87a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, November 25, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:
Companies can have slightly different titles for the same j= ob; for example
(using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Ge= n Mgr,'. 'Mgr,',
'Plant Mgr.'

Suggest encoding that knowledge in a table= then using normal joins and filters to query against whatever you;ve decid= ed is the canonical spelling of the relevant position.

=
David J.
--0000000000000436f9064471c87a--