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@xxxxxxxxxxx}
2 | {aklaver@xxxxxxxxxxx}
Adrian, Given my inexperience with arrays this seems to be the simplest of all offered syntaxes. Another valuable postgres lesson learned. Much appreciated, Rich
