On Tue, Apr 28, 2020 at 5:40 PM Rui DeSousa <rui@xxxxxxxxxxxxx> wrote:
To increase a column length does not require a table rewrite or table scan; however, reducing its size will require a full table scan. So cleaning up a schema like the one proposed sucks.
I estimate the probability of ever desiring to reduce the length of a varchar field to be indistinguishable from zero.
David J.
