Re: patch: Add columns via CREATE OR REPLACE VIEW

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