From: | Ralph Smith <smithrn(at)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Overloading |
Date: | 2008-06-14 01:11:43 |
Message-ID: | 8B4F4031-2363-4C3C-A851-4B0947499502@washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-06-14 02:45:04 | Re: Overloading |
Previous Message | Kynn Jones | 2008-06-13 22:08:20 | Advice for "hot-swapping" databases |