Andrew Dunstan escribió: > > > Tom Lane wrote: >> Maybe the right way is to *not* use CREATE OR REPLACE VIEW, but >> rather ALTER VIEW ADD COLUMN and so on. Then column identity seems >> a lot easier to keep track of. > > How would that look? Where would we put the new query?
I was thinking that the ADD COLUMN should specify the new result list entry. Of course, this doesn't allow changing the query in more complex ways (e.g. you can't add a GROUP BY clause that wasn't already there). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
