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(dot)klaver(at)aklaver(dot)com}
> 2 | {aklaver(at)example(dot)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