John McCawley <[EMAIL PROTECTED]> schrieb: > I believe that it makes a lot of practical difference, just like organizing > related code into files, classes etc. is important for clarity. This isn't > a trivial thing, and the other (sarcastic?) suggestion that I reorder my > select misses the point.
Not really sarcastic. You can't expect the order of values in a table, and you can't expect the order of columns in a table. If you do a 'select * from ...', and the table-structure is changed, then you get problems. If you do a 'select col1, col2, col2, ... coln ...'), no problems. A (german) article about this (with mysql): http://php-faq.de/q/q-sql-select.html HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
