Hi, Am Dienstag, den 30.11.2004, 10:26 +0100 schrieb Joolz: > Hello everyone, > > When I create a table and later on (say, because customers want to > store extra info) add a column, like this: > > create table test (lastfield varchar); > alter table test add column firstfield varchar; > > is it possible to change the natural order of the columns > afterwards? The reason I need this is because the frontend picks up > table columns in natural order, looks at the datatype and creates > view, input and mutate (html) forms. > > I'd rather not use views, allthough I know this is "the right way", > because it would make the application a lot more complex. > > Can I dive into some system tables and change the natural order?
Natural Order? This is similar to a select without order by - the SQL standard says nothing about a natural order. If you want to have a given ordering, why not just specify your column names in that order in your statements? Or just refer to them by column name if your host language allows it. I dont think the overhead in implementing such a rarely needed feature isnt worth it. We need a lot more other things ;-) Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
