Re: What is the point of create or replace view command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the point of create or replace view command
Date: 2006-06-05 02:44:50
Message-ID: 7988.1149475490@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2006-06-05 03:39:44 Re: PGSQL 7.4 -> 8.1 migration & performance problem
Previous Message Berend Tober 2006-06-05 02:02:35 Re: What is the point of create or replace view command