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> <CAKFQuwYGP6geSx61RUuvH07D+CDHWOiZNXi+WpB3U=QJ7h_Dgg@mail.gmail.com>
 <286181eb-9fdd-6680-de4-edcdc82d42a9@appl-ecosys.com>
In-Reply-To: <286181eb-9fdd-6680-de4-edcdc82d42a9@appl-ecosys.com>
From: =?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.com>
Date: Wed, 3 Jul 2024 16:21:39 +0200
Message-ID: <CAKkG4_nzcBWejwRdwenPvNE4RuMMJFzKOWSCpTywCYRs+W2pOg@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="0000000000003b1bf0061c588d99"
Archived-At: <https://www.postgresql.org/message-id/CAKkG4_nzcBWejwRdwenPvNE4RuMMJFzKOWSCpTywCYRs%2BW2pOg%40mail.gmail.com>
Precedence: bulk

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

Check this out
https://www.postgresql.org/docs/16/arrays.html#ARRAYS-INPUT

You can use
    ('{' || email || '}')::varchar(64)[]

or the syntax I suggested earlier.

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

> On Wed, 3 Jul 2024, David G. Johnston wrote:
>
> > Yeah, the simply cast suggested will not work. You=E2=80=99d have to ap=
ply an
> > expression that turns the current contents into an array. The current
> > contents are not likely to be an array literal.
>
> David,
>
> No, it's not now an array.
>
> I thought that this expression would work, but it doesn't:
> bustrac=3D# alter table people alter column email set data type
> varchar(64)[] using email::varchar(64)[];
> RROR:  malformed array literal: "frank@dmipx.com"
> DETAIL:  Array value must start with "{" or dimension information.
>
> If I correctly understand the error detail I'd need to change the content=
s
> of that column for all 1280 rows to enclose the contents in curly braces
> before I can convert the datatype to an array. Is that correct?
>
> Rich
>
>
>

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

<div dir=3D"ltr"><div>Check this out</div><a href=3D"https://www.postgresql=
.org/docs/16/arrays.html#ARRAYS-INPUT">https://www.postgresql.org/docs/16/a=
rrays.html#ARRAYS-INPUT</a><br><div><br></div><div>You can use</div><div>=
=C2=A0 =C2=A0 (&#39;{&#39; || email || &#39;}&#39;)::varchar(64)[]</div><di=
v><br></div><div>or the syntax I suggested earlier.</div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jul 3, 202=
4 at 4:13=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, David G. Johnston wrot=
e:<br>
<br>
&gt; Yeah, the simply cast suggested will not work. You=E2=80=99d have to a=
pply an<br>
&gt; expression that turns the current contents into an array. The current<=
br>
&gt; contents are not likely to be an array literal.<br>
<br>
David,<br>
<br>
No, it&#39;s not now an array.<br>
<br>
I thought that this expression would work, but it doesn&#39;t:<br>
bustrac=3D# alter table people alter column email set data type varchar(64)=
[] using email::varchar(64)[];<br>
RROR:=C2=A0 malformed array literal: &quot;<a href=3D"mailto:frank@dmipx.co=
m" target=3D"_blank">frank@dmipx.com</a>&quot;<br>
DETAIL:=C2=A0 Array value must start with &quot;{&quot; or dimension inform=
ation.<br>
<br>
If I correctly understand the error detail I&#39;d need to change the conte=
nts<br>
of that column for all 1280 rows to enclose the contents in curly braces<br=
>
before I can convert the datatype to an array. Is that correct?<br>
<br>
Rich<br>
<br>
<br>
</blockquote></div>

--0000000000003b1bf0061c588d99--