On Wednesday, July 29, 2020, Holger Jakobs <holger@xxxxxxxxxx> wrote:
That columns appear to have some kind of order and show in tools with a stable order has technical reasons and is not rooted in relational theory.Technical reasons are real reasons. The order of columns is very real, guaranteed (beware of inherits), thing in PostgreSQL whereas there is no guarantee regarding row order outside of a select query order by. That said I do agree that fulfilling “ocd” drives isn’t a strong use case to work on the feature.
As for the theory, a tuple is an ordered list so the ordering of columns is a precise application of that definition and a relation is just a set (i.e., unordered) of tuples. So the claim this isn’t rooted in relational theory just seems wrong.
David J.
