Re: Accommodating alternative column values

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Accommodating alternative column values
Date: 2024-07-02 21:57:46
Message-ID: 449bdf5-31d-9189-34d-5ce4188fe2@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2 Jul 2024, Christophe Pettus wrote:

> 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 to the owning record.

Christophe,

Using text rather than varchar() is a good suggestion.

Thank you,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-07-02 21:59:19 Re: Accommodating alternative column values
Previous Message Christophe Pettus 2024-07-02 21:50:27 Re: Accommodating alternative column values