Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)

On 12 Oct 2002 at 2:54, Jeff Davis wrote:

> As far as I can tell, the order the attributes are returned makes no 
> difference in a client application, unless you're referencing attributes by 
> number. All applications that I've made or seen all use the name instead, and 
> I've never heard otherwise, or heard any advantage to using numbers to 
> reference columns. 

Even in that case you can obtain field number for a given name and vise versa..

> When someone asks, ask them "why?". I'd be interested to know if they have 
> some other reason. I would think that if they absolutely wanted to fine-tune 
> the order of columns they'd use a view (seems a little easier than 
> continually changing order around by individual SQL statements). 

Sounds fine but what is about that "continually changing"? A view needs a 
change only if it alters fields selected/tables to select from/selection 
criteria. Field order does not figure in there..

ByeShridhar

--
QOTD:    "A child of 5 could understand this!  Fetch me a child of 5."