Re: request

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