MIME-Version: 1.0
In-Reply-To: <3eb9a2d3-28c-9066-d3b5-fd6cca32af9@appl-ecosys.com>
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>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 3 Jul 2024 07:05:36 -0700
Message-ID: <CAKFQuwYGP6geSx61RUuvH07D+CDHWOiZNXi+WpB3U=QJ7h_Dgg@mail.gmail.com>
Subject: Re: Accommodating alternative column values
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001d8dd9061c5853c2"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYGP6geSx61RUuvH07D%2BCDHWOiZNXi%2BWpB3U%3DQJ7h_Dgg%40mail.gmail.com>
Precedence: bulk

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

On Wednesday, July 3, 2024, Rich Shepard <rshepard@appl-ecosys.com> 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.
>
>
Yeah, the simply cast suggested will not work.  You=E2=80=99d have to apply=
 an
expression that turns the current contents into an array.  The current
contents are not likely to be an array literal.

David J.

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

<br><br>On Wednesday, July 3, 2024, Rich Shepard &lt;<a href=3D"mailto:rshe=
pard@appl-ecosys.com">rshepard@appl-ecosys.com</a>&gt; wrote:<br><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">On Wed, 3 Jul 2024, Rich Shepard wrote:<br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
What I&#39;ve tried:<br>
bustrac=3D# alter table people alter column email set data type varchar(64)=
 [];<br>
ERROR:=C2=A0 column &quot;email&quot; cannot be cast automatically to type =
character varying[]<br>
HINT:=C2=A0 You might need to specify &quot;USING email::character varying(=
64)[]&quot;.<br>
</blockquote>
<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>
</blockquote><div><br></div><div>Yeah, the simply cast suggested will not w=
ork.=C2=A0 You=E2=80=99d have to apply an expression that turns the current=
 contents into an array.=C2=A0 The current contents are not likely to be an=
 array literal.</div><div><br></div><div>David J.</div>

--0000000000001d8dd9061c5853c2--