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.kla...@aklaver.com} 2 | {akla...@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
