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

On 6/5/06, brian ally wrote:
> Chris Velevitch wrote:
> > 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.

Ok, so postgres allows function overloading. That makes that if you
need to change the parameter list or result type, so you need to drop
the function to change teh parameter list or result type.

But what about my original question?

"What is the point of the create or replace view command if you
can't change the
column and data types?"

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au