| 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: | Whole Thread | Raw Message | 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
| 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? |