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 1sP0Zr-002RHe-VQ for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 14:03:19 +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 1sP0Zp-009Ewf-Ud for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 14:03:18 +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 1sP0Zp-009EwW-Jg for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 14:03:18 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sP0Zo-000EG1-BJ for pgsql-general@postgresql.org; Wed, 03 Jul 2024 14:03:17 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5c405dad8b6so2619059eaf.2 for ; Wed, 03 Jul 2024 07:03:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720015394; x=1720620194; darn=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=N7gft6cFKHCeRHKIcRfdt6ddhHtcyv5sKty2qEukIuk=; b=bJfSujAcRkyzRGIxbD0sfNKql/ohAwkA2rASv1Rbv2Vu70dPFYYExtauivYcv9wyi0 UVfKETisxQvmxa9v5NRWkT0qs2tcAAPHNa8oEJTcNLsRiq9V0nBTbrUx1Lu1ycSq2vZd v6eSIi7l0jQmz+I2esq/v3ka3snZGZzHCTldcGGwTHsO+0M6q/efxr7guPfNZCRf3/ML m2M8mICGN37jquP+5e4qs589QzjgV4Mz8hVpuiPtYuZG9P+kRvODojsUYsvd0H38/oAc Bit5bg6lTTAAuHljK/ZEz8Xgw3+bYnU1BjsCbqdip6pxiIcYYP6/MoT63Xu17E+1kQAI TGyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720015394; x=1720620194; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=N7gft6cFKHCeRHKIcRfdt6ddhHtcyv5sKty2qEukIuk=; b=uxGlpF406gM0J4Z6ttfjwZtaMB4v3UeL4cSHB/bHoOZwVSsaGBe7vFcUATlikmu1Gh EFbAbqipMEIKBCU9ANuxdxZRvl79ddgaJyYsqM3xXgZxMnUSPBEhSDB2Xj9u0rPdfZX8 NX08lvh29V1QKixyiAogRVhIcb66VSYkhnfr61NrWFYogGXoUnuEENCmoo4LuOB/Ho3n lfLq6mDpn8rNoVxqRKx6jadBTbxi1X80jQZoCB5iaF5Dcmj1IV+SOti4Lv0HNV/On8XD Gv/a470chI/bZkdsEd2sc6qWQRcrqItDdikJsSkzzOymR6fgSsBesNXz0DxloHchiopg UswQ== X-Gm-Message-State: AOJu0Yz6TsxiKAnvCdm94R/hpxf/2O2vXzGjs26NgBPnhLcuhWXQSr5+ 2gmMFt0fO4NP0Jd5l2JWvZnN3m9aRkeDwsyMQjAJyxuuTamLsgD/TugYC6t38EztT0Wru8GxLto fQKlb9M3L7gaB9Q1JIAO2hY+k9srONA== X-Google-Smtp-Source: AGHT+IFmdtV3zNS1HzSD0nChd+MZZ/x9gauNFAAlnLG3pReGVXZzoPXroCnsr0iRtBGfF5nk4enw/WjYQEgEs6bn4QA= X-Received: by 2002:a05:6870:65a8:b0:25e:7a9:b5f0 with SMTP id 586e51a60fabf-25e07a9c654mr2398935fac.48.1720015393772; Wed, 03 Jul 2024 07:03:13 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6850:0:b0:539:aa10:6c7 with HTTP; Wed, 3 Jul 2024 07:03:13 -0700 (PDT) In-Reply-To: <74f52ac6-61cb-f995-34e5-16271b5c6832@appl-ecosys.com> References: <449bdf5-31d-9189-34d-5ce4188fe2@appl-ecosys.com> <74f52ac6-61cb-f995-34e5-16271b5c6832@appl-ecosys.com> From: "David G. Johnston" Date: Wed, 3 Jul 2024 07:03:13 -0700 Message-ID: Subject: Re: Accommodating alternative column values To: Rich Shepard Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008ddbb5061c584a52" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008ddbb5061c584a52 Content-Type: text/plain; charset="UTF-8" On Wednesday, July 3, 2024, Rich Shepard wrote: > > I'm not using the proper syntax and the postgres alter table doc has no > example in the alter column choices. Simpler syntax forms tend to get skipped over when doing examples. > > How do I incorporate the "USING email::..." string? > ALTER [ COLUMN ] *column_name* [ SET DATA ] TYPE *data_type* [ COLLATE *collation* ] [ USING *expression* ] David J. --0000000000008ddbb5061c584a52 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, July 3, 2024, Rich Shepard <rshepard@appl-ecosys.com> wrote:

I'm not using the proper syntax and the postgres alter table doc has no=
example in the alter column choices.

Simple= r syntax forms tend to get skipped over when doing examples.
=C2= =A0

How do I incorporate the "USING email::..." string?

ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLA= TE = collation ] [ USING expression= ]

David J.

--0000000000008ddbb5061c584a52--