Ken Johanson <pg-user@xxxxxxxxxxxxx> writes: > While the values of an API that specifies the table's columns by > ordinaility may seem dubious, it is an API that I think should be > implemented anyway. Every few weeks we get a complaint from someone who thinks that it should be easy to rearrange the logical order of table columns. If that comes to pass, it would be a seriously bad idea to have encouraged applications to rely on table column numbers. And given the number of votes for that (probably in the hundreds by now) versus the number of votes for this idea (one), I think column reordering is much more likely to get done ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match