Re: Accommodating alternative column values

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Accommodating alternative column values
Дата
Msg-id D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306@thebuild.com
обсуждение исходный текст
Ответ на Accommodating alternative column values  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Accommodating alternative column values
Список pgsql-general

> On Jul 2, 2024, at 14:47, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> Is there a way
> to accommodate multiple email addresses other than entering both with a
> forward slash separating them in the varchar(64) email address column?

If you are absolutely 100% sure there will never be any metadata associated with each email address (like a "valid"
flag),you can use TEXT[] array to store them.  Otherwise, it's best to move them into a table with a foreign key back
tothe owning record. 


В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Accommodating alternative column values
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Accommodating alternative column values