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 <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1vaxsK-00GXIN-1H
	for pgsql-novice@arkaria.postgresql.org;
	Wed, 31 Dec 2025 15:12:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1vaxsJ-006ZSa-08
	for pgsql-novice@arkaria.postgresql.org;
	Wed, 31 Dec 2025 15:12:35 +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.96)
	(envelope-from <htamfids@gmail.com>)
	id 1vaxsI-006ZSS-2U
	for pgsql-novice@lists.postgresql.org;
	Wed, 31 Dec 2025 15:12:35 +0000
Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <htamfids@gmail.com>)
	id 1vaxsF-003n2c-15
	for pgsql-novice@lists.postgresql.org;
	Wed, 31 Dec 2025 15:12:33 +0000
Received: by mail-oo1-xc33.google.com with SMTP id
 006d021491bc7-657044fea68so6145408eaf.0
        for <pgsql-novice@lists.postgresql.org>;
 Wed, 31 Dec 2025 07:12:30 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1767193949; x=1767798749;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=NOwJ5mf5B6teBqAJEZhYGN2NYVKxrpkbw5ByIi/avkM=;
        b=OH0foqMMBOZKxrB2vvwCrWfhIQf6Jl1H4MGWwmwKV9keuCgAcXz5hRjwyGnsRjg/ul
         ldE5+PUtdSlH8ycjjoplXMTCA2GU0s+4UMEpK+UQXPpJK7hUnxbyMKWarf/+vsqvIzKp
         Fr3w7mjPSqBa8v3DjDgCfZgh7C9r40vBGJniQccjfQoJS1OFHuLPsLDpxJU8yJWgpg7w
         aLg3OObRKaF/pLvdWqQ8oOqpIyqBrciraNhEVdG1dSmuT3+KxIg3FG/2F0qGZLqgMqVC
         ySn5MSYXf7g46Vewb5AmTXp2wA3bu0IeFlY6OPEZcTO29EpUaE8rt2eXy0lLWie/SQpf
         UNuQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1767193949; x=1767798749;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=NOwJ5mf5B6teBqAJEZhYGN2NYVKxrpkbw5ByIi/avkM=;
        b=I8bVn3M6uYeJ1KYL+BBo4/+ehCKMmo9fojb25fkLzP83lCyd4WtzIbOaVq+6NVb/P+
         dmXyoMlHmQd2ISbRXPTo28fCSkEUreH9GKd9SZ4/uIDQs4lrQ7CXzmIsjMUbgLPN15gG
         n/hwGmTS814tLaLduzGGqgF7RE+BQSdm4gGcIS0efIMVhamVHHxadpR09zaV4X4VPJ/6
         OZXUTE9vzs1X1joLJ7za5jUmwO4XIVodjpv3XeDQ3489bLRIBgF+AHR7UV7SqirdrNeW
         tPVSUOPIFcxOyCUCch4VZTtl8LZefMRfAOoAt6mZCKUJSr/H9Ym+n9fBxQiO7cFiHyUw
         WtCQ==
X-Gm-Message-State: AOJu0YypE/APiCSiimD7mt4e40a9LeGiHVzmqOa2ExX6xAigAXxZQyXz
	ozjJpS/L36x6GcV8npS0BlnFPjCOJ3eNrqmr+YOFVazv2kH6fa6jIF2dxdS41lpIG3NRFR/zonz
	La/b3WjObpAgHs02bgOMVtQLk6/0+ZJ8BWA==
X-Gm-Gg: AY/fxX6U3SkSGkYzi0ph687LZeye041a2WiElMs1HmwCO2zKSd2yaIvP91/LMVTubWk
	LKxE7p7lmoYhSKWNNcelOpXKkHLippCKcwAfv0BeMnYSX5l1G+QAchFRRbl3xVqPuAtQXJufIIr
	vMCaMFn1YctVI0MhSBQaSswspgepNm3I5jf7I3ZF/yCBeJVY1bPnweJoqzRkZl9mAczUsF11+/B
	iCvvBlBMbPew6wS1sYrDr+lSyghIZHL4Dmw4Zlsy91hCmK2RCnL6foGNEiD5v7l7uKhFwsAq3Zd
	5SmvYbt0YLDZE9/IA1kLCvKvtw30Kw==
X-Google-Smtp-Source: 
 AGHT+IGUVeiTGYeQAyQepGdXLwviBGdtL2mQg9IJ8W7GeWkgjbjhGFjX/eYVKUAaLu9qaegVVLSyw2wAfLsm30xcYvI=
X-Received: by 2002:a05:6820:4901:b0:659:9a49:8e15 with SMTP id
 006d021491bc7-65cfe66725cmr13305007eaf.7.1767193949018; Wed, 31 Dec 2025
 07:12:29 -0800 (PST)
MIME-Version: 1.0
References: 
 <DM4PR12MB603953767048EE1B8A39283ADDB1A@DM4PR12MB6039.namprd12.prod.outlook.com>
In-Reply-To: 
 <DM4PR12MB603953767048EE1B8A39283ADDB1A@DM4PR12MB6039.namprd12.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 31 Dec 2025 10:11:52 -0500
X-Gm-Features: AQt7F2pvJ38KPnXbkp86qm98gjuUWTs_DkvnM6wevKBJM1f5EPgRQItNFoFB-Yg
Message-ID: 
 <CAKAnmmL1UZcP_SUotSRpDD2a6+k4qCRWvFGawDb6-JkXY0Rmbw@mail.gmail.com>
Subject: Re: is there a way to automate deduplication of strings?
To: Chris Papademetrious <Christopher.Papademetrious@synopsys.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000949ead064740e757"
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmL1UZcP_SUotSRpDD2a6%2Bk4qCRWvFGawDb6-JkXY0Rmbw%40mail.gmail.com>
Precedence: bulk

--000000000000949ead064740e757
Content-Type: text/plain; charset="UTF-8"

It is not quite clear what you are trying to do. Can you provide a small
test table to show what you want to achieve?

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000949ead064740e757
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">It is not quite clear what you are trying=
 to do. Can you provide a small test table to show what you want to achieve=
?</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">Cheers,</div><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>Greg</div><div><br></=
div><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com=
" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Po=
stgres Software Products &amp; Tech Support</div><div><br></div></div></div=
></div>

--000000000000949ead064740e757--