Thread: what is the error in the function?

what is the error in the function?

From
efreyre@qnet.com.pe
Date:
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 trav�s de Qnet
http://www.qnet.com.pe



Re: what is the error in the function?

From
"Aasmund Midttun Godal"
Date:
As the error message suggests you may need to cast the types so that it knows what kind of data you are putting in,
perhapslike so: 

select nr_renewlease('111.111.111.111'::VARCHAR,'50 seconds'::TIMESTAMP)

I am not sure, look it up in the docs.

Regards,
Aasmund.
On Thu, 8 Nov 2001 17:52:51 GMT, efreyre@qnet.com.pe wrote:
> 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 través de Qnet
> http://www.qnet.com.pe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46