Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the point of create or replace view command - Mailing list pgsql-general

From Tom Lane
Subject Re: What is the point of create or replace view command
Date
Msg-id 7988.1149475490@sss.pgh.pa.us
Whole thread Raw
In response to What is the point of create or replace view command  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Responses Re: What is the point of create or replace view command
List pgsql-general
Tree view 
"Chris Velevitch" <chris.velevitch@gmail.com> writes:
> What is the point of the create or replace view command if you can't
> change the column and data types ?

You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you change the function's parameter list or result
type.  The analogy to result type is pretty exact, in fact.

            regards, tom lane

pgsql-general by date:

Previous
From: Berend Tober
Date:
Subject: Re: What is the point of create or replace view command
Next
From: Lincoln Yeoh
Date:
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem