what is the error in the function?

From: efreyre(at)qnet(dot)com(dot)pe
To: pgsql-general(at)postgresql(dot)org
Subject: what is the error in the function?
Date: 2001-11-08 17:52:51
Message-ID: 200111081752.fA8Hqvm11047@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Sirs:

Please I have a function as:

create function nr_renewLease(varchar(15),interval)
returns integer as '
DECLARE
local_address ALIAS FOR $1;
lease_duration ALIAS FOR $2;
BEGIN
update nr_lease set expires=now()+lease_duration where
address=local_address;
END;
return 1;
'
language 'plpgsql';

When I called this function so:

select nr_renewlease('111.111.111.111','50 seconds')

I get the follow error :

ERROR: Function 'nr_renewlease(unknown, unknown)' does not
exist Unable to identify a function that satisfies the given
argument types You may need to add explicit typecasts.

I don't know where is the fail.

I will thank if you can help me to clarify this.

Regards,

Ernesto

---------------------------------------------
Este mensaje fue enviado a travs de Qnet
http://www.qnet.com.pe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-11-08 18:14:41 Re: OT?: PGReplication project dead?
Previous Message Bradley McLean 2001-11-08 17:40:02 Re: OT?: PGReplication project dead?