In PostgreSQL it’s possible to make an array larger without providing any values. For example, we can take an array with three elements, and enlarge it so that it contains say, five elements, with the two extra elements being NULL
.
We can also do it so that some of the extra elements are non-NULL
and others are NULL
.