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 1sP1ez-002WZL-79 for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 15:12:41 +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 1sP1ev-00ADWh-7e for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 15:12:37 +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 ) id 1sP1eu-00ADUY-Sr for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 15:12:37 +0000 Received: from mail.appl-ecosys.com ([50.126.108.78]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sP1et-000Elg-N1 for pgsql-general@postgresql.org; Wed, 03 Jul 2024 15:12:36 +0000 Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1]) by mail.appl-ecosys.com (Postfix) with ESMTP id 9C9F32A2B7C for ; Wed, 3 Jul 2024 08:12:32 -0700 (PDT) Date: Wed, 3 Jul 2024 08:12:32 -0700 (PDT) From: Rich Shepard To: "pgsql-general@postgresql.org" Subject: Re: Accommodating alternative column values [RESOLVED] In-Reply-To: <39759897-4e11-4c3d-a7ab-f7e6a8c479aa@aklaver.com> Message-ID: <27548f14-d1b6-e37c-574f-47d78293b765@appl-ecosys.com> References: <449bdf5-31d-9189-34d-5ce4188fe2@appl-ecosys.com> <74f52ac6-61cb-f995-34e5-16271b5c6832@appl-ecosys.com> <3eb9a2d3-28c-9066-d3b5-fd6cca32af9@appl-ecosys.com> <286181eb-9fdd-6680-de4-edcdc82d42a9@appl-ecosys.com> <39759897-4e11-4c3d-a7ab-f7e6a8c479aa@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 3 Jul 2024, Adrian Klaver wrote: > alter table array_conv alter column email type varchar[] using array[email]; > > select * from array_conv ; > id | email > ----+----------------------------- > 1 | {adrian.klaver@aklaver.com} > 2 | {aklaver@example.com} Adrian, Given my inexperience with arrays this seems to be the simplest of all offered syntaxes. Another valuable postgres lesson learned. Much appreciated, Rich