On Wednesday, July 3, 2024, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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.
Yeah, the simply cast suggested will not work. You’d have to apply an _expression_ that turns the current contents into an array. The current contents are not likely to be an array literal.
David J.
