Overloading

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

Responses

Browse pgsql-general by date

  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