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