From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)
Date: Sat, 12 Oct 2002 16:20:03 +0530
Message-ID: <3DA84BB3.19627.31201C@localhost> (raw)
In-Reply-To: <200210120254.20255.list-pgsql-hackers@empires.org>
References: <Pine.LNX.4.21.0210121833480.26079-100000@linuxworld.com.au>
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..
Bye
Shridhar
--
QOTD: "A child of 5 could understand this! Fetch me a child of 5."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: shridhar_daithankar@persistent.co.in
Subject: Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)
In-Reply-To: <3DA84BB3.19627.31201C@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox