John R Pierce wrote:
I would really like postgres to model the alter syntax of mysql, which is really easy to modify table schema especially to include the AFTER col_name part.
A) why does the order of the columns in a particular table matter at all?
If coding without caring (about portability/robustness), unfortunately programmers are seduced by MySQL to work like that..
B) is this any sort of SQL standard?
Definitely no.
Do not use SELECT * if you need a specific column ordering, *that* is SQL standard.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
