Chris Velevitch wrote:
On 6/5/06, Tom Lane wrote:
"Chris Velevitch" <chris.velevitch@xxxxxxxxx> 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
