Tom Lane wrote:
Actually, the more I think about it the more I think that 3 numbers might be the answer. 99% of the code would use only the permanent ID. Display position would be used in *exactly* one place, namely while expanding "SELECT foo.*" --- I can't think of any other part of the backend that would care about it.
Insert without a column list will need the logical ordering, I think. Also use of "like foo" in a create table statement. I'm not dead sure there aren't one or two others lurking. But I agree that the number is small.
cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings