From: | "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE : full featured alter table? |
Date: | 2003-06-17 11:21:08 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAU9RPasisJU6SRBuchwpMJgEAAAAA@baguette.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > > Presentation order should be done at the application level.
>
> I agree.
>
> Use a VIEW for the presentation!
>
Sorry, but I don't fully agree with you. If I have to add a new column
in a table, this column will appear in the end of the table. What we are
talking about (as I understand) is to have the possibility to order the
columns table (via ALTER TABLE ...POSITION..). SELECT * FROM <table>
would use that order to display the columns.
We are not talking of changing columns order for each kind of SQL query.
In that case, I agree that views are usefull and when we want to
display several tables in one "pseudo-table" (a view) and to have less
big queries.
I really think that column ordering (ALTER TABLE ...POSITION..) is very
interesting and will allow users to avoid loosing time when they have to
create a new temporary table each time they have to add a new column
inside (not at the end of) a table, and rename the table after deleting
the old table... :-)
Regards,
---------------------------------------
Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Sven Köhler | 2003-06-17 11:40:40 | Re: RE : full featured alter table? |
Previous Message | Nigel J. Andrews | 2003-06-17 10:56:28 | Re: Damn triggers and NEW |