Overloading

[Ralph Smith <smithrn@xxxxxxxxxxxxxx>]

I never did get an answer to this.

I get:

ERROR:  cannot change return type of existing function

HINT:  Use DROP FUNCTION first.

********** Error **********

ERROR: cannot change return type of existing function

SQL state: 42P13

Hint: Use DROP FUNCTION first.

When I try to:

  CREATE OR REPLACE FUNCTION check_date_ymd(given_date varchar) RETURNS BOOLEAN  AS

and

  CREATE OR REPLACE FUNCTION check_date_ymd(given_date varchar, OUT isvalid boolean, OUT ryear int, OUT rmonth int, OUT rday int)  AS

I wanted to an 'is it valid' version, and another that would save runtime by also returning values that would speed up the

function date_to_utime().

in pg_proc there is no 'check_date_ymd', so there is no 'collision'.

Can someone elucidate me on this?

Thanks!

Ralph