From: | qradius(at)qnet(dot)com(dot)pe |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with function |
Date: | 2001-11-08 18:56:45 |
Message-ID: | 200111081857.fA8Iuxm13316@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Please ; i have a function denfined 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 calle the functions as:
select nr_renewLease('192.168.100.1','20 seconds');
I get the follow error:
ERROR: Function 'nr_renewlease()' does not exist
Unable to identify a function that satisfies the given
argument types
You may need to add explicit typecasts
But I don't know why, since I can see sintaxis of my function
is fine, and the passed arguments are fine, Can you help me,
if exists some detail I am not seeing?
I can see that this error message also appears when a function
that doesn't exists is called, but my function exists!
Thank you.
Regards.
Ernesto Freyre
---------------------------------------------
Este mensaje fue enviado a travs de Qnet
http://www.qnet.com.pe
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Korff | 2001-11-08 19:13:27 | Re: High Availability Cluster in Conjunction with PostGres |
Previous Message | Marc G. Fournier | 2001-11-08 18:33:15 | Re: OT?: PGReplication project dead? |