> To be clear, I wasn't suggesting stuffing them all into a text column with > a delimiter, but storing them in a text *array* field, each email address > one component of the array.
Christophe,
I'm not using the proper syntax and the postgres alter table doc has no example in the alter column choices.
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)[]".
How do I incorporate the "USING email::..." string?