The USING phrase basically answers the question how do I convert an existing value of the old type to the new type.
On Wed, Jul 3, 2024 at 4:03 PM Rich Shepard <rshep...@appl-ecosys.com> wrote: > On Wed, 3 Jul 2024, Rich Shepard wrote: > > > What I've tried: > > bustrac=# alter table people alter column email set data type > varchar(64) []; > > ERROR: column "email" cannot be cast automatically to type character > > varying[] > > HINT: You might need to specify "USING email::character varying(64)[]". > > What I forgot to mention is that the current datatype is varchar(64) and I > want to make it an array. > > Rich > > >
