MIME-Version: 1.0
References: <fd94aff-aec9-1b3d-64c6-16b0eaeccc58@appl-ecosys.com>
 <D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306@thebuild.com> <449bdf5-31d-9189-34d-5ce4188fe2@appl-ecosys.com>
 <B90F940C-8532-4D21-8242-E0E764CE80AE@thebuild.com> <74f52ac6-61cb-f995-34e5-16271b5c6832@appl-ecosys.com>
 <3eb9a2d3-28c-9066-d3b5-fd6cca32af9@appl-ecosys.com>
In-Reply-To: <3eb9a2d3-28c-9066-d3b5-fd6cca32af9@appl-ecosys.com>
From: =?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.com>
Date: Wed, 3 Jul 2024 16:06:45 +0200
Message-ID: <CAKkG4_nEYBZriL9n1GiyEnutTAbLBuFg=sKzCENw40LXR-NgSQ@mail.gmail.com>
Subject: Re: Accommodating alternative column values
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f0c109061c5857e2"
Archived-At: <https://www.postgresql.org/message-id/CAKkG4_nEYBZriL9n1GiyEnutTAbLBuFg%3DsKzCENw40LXR-NgSQ%40mail.gmail.com>
Precedence: bulk

--000000000000f0c109061c5857e2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The USING phrase basically answers the question how do I convert an
existing value of the old type to the new type.

On Wed, Jul 3, 2024 at 4:03=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.c=
om>
wrote:

> On Wed, 3 Jul 2024, Rich Shepard wrote:
>
> > What I've tried:
> > bustrac=3D# alter table people alter column email set data type
> varchar(64) [];
> > ERROR:  column "email" cannot be cast automatically to type character
> > varying[]
> > HINT:  You might need to specify "USING email::character varying(64)[]"=
.
>
> What I forgot to mention is that the current datatype is varchar(64) and =
I
> want to make it an array.
>
> Rich
>
>
>

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

<div dir=3D"ltr">The USING phrase basically answers the question how do I c=
onvert an existing value of the old type to the new type.</div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jul 3, 202=
4 at 4:03=E2=80=AFPM Rich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosy=
s.com">rshepard@appl-ecosys.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On Wed, 3 Jul 2024, Rich Shepard wrote:<br=
>
<br>
&gt; What I&#39;ve tried:<br>
&gt; bustrac=3D# alter table people alter column email set data type varcha=
r(64) [];<br>
&gt; ERROR:=C2=A0 column &quot;email&quot; cannot be cast automatically to =
type character <br>
&gt; varying[]<br>
&gt; HINT:=C2=A0 You might need to specify &quot;USING email::character var=
ying(64)[]&quot;.<br>
<br>
What I forgot to mention is that the current datatype is varchar(64) and I<=
br>
want to make it an array.<br>
<br>
Rich<br>
<br>
<br>
</blockquote></div>

--000000000000f0c109061c5857e2--