Re: RE : full featured alter table? - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: RE : full featured alter table?
Date
Msg-id 3EEE19D4.2070403@wildenhain.de
Whole thread Raw
In response to RE : full featured alter table?  ("Bruno BAGUETTE" <pgsql-ml@baguette.net>)
Responses Re: RE : full featured alter table?
List pgsql-general
Hi,

Bruno BAGUETTE wrote:
> Hello,
>
>
>>why not just order the output columns in alphabetical order?
>>This is quite easy to implement and requires no additional
>>storage. The output would be the same all the time and with all tools.
>
>
> No, what we are talking about is to have the possibility to choose the
> output order of the columns of a table (by adding a field in the
> pg_attribute table).

Sure, I did understand that. But I think it is quite pointless
to burden the db or the app with such functionality.
Just to have random ordered columns which do not correspondent
to any physical ordering by the db.
So it does not influence query performance to arrange the
selected columns this or that order. So why confusing
the user by pretending it has any meaning to order the columns?

I think there are quite more praxis relevant problems to solve :)

Regards
Tino


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Finding Current Page Size
Next
From: "Andrew J. Kopciuch"
Date:
Subject: Re: tsearch - v2