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

Chris Velevitch wrote:
> On 6/5/06, Tom Lane wrote:
>
>> "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.
>
>
> Yes, please, what is point of CREATE OR REPLACE FUNCTION, when it
> doesn't let you change the function's parameter list or result type?
>
>

The way that user-created functions work allows one to have the same
function name with different numbers & types of parameters. Thus, you
must specify the param list when replacing.

Now, having default values for params might be nice. Is that possible?

brian