-----Original Message----- From: jcasa...@systemguards.com.ec [mailto:jcasa...@systemguards.com.ec] On Behalf Of Jaime Casanova Sent: 18 March 2012 01:04 To: Atri Sharma Cc: Dave Page; Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012
On Sat, Mar 17, 2012 at 2:16 PM, Atri Sharma <atri.j...@gmail.com> wrote: > Hi Dave, > > I believe,with the ALTER command,we plan to give the user power to modify > ordering . Dont we? > And how is that different from a view that orders the columns as the user wishes? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -------------------------------------- Hi Jaime , Well, I believe, my idea is more towards the layers already present in database systems, rather than views. 1) Views are just a window to some(or all) part of a database. There are many restriction on views, none of which are applicable to our middle layer. This is so because, even though the middle layer is encapsulating the addressing and mapping details from the user , it still provides complete access and rights to the database according to the user's privilege level. 2) Views are optional, wherever our middle layer is built right in the database. It is not optional. User can only see the middle layer. It cannot directly interact with the underlying layers. Please let me know your feedback and comments. Atri -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
