Re: Error on function parameters

On Wed, 30 Aug 2006, Ezequias Rodrigues da Rocha wrote:

> Hi list
>
> I am doing an statement like this:
>
> select insertPoints('C', '123456789', 12.5, 1, 9877000000944005, 104)
>
> and get the following error:
>
> ERROR:  function inserirpontos("unknown", "unknown", numeric, integer,
> bigint, integer) does not exist
> HINT:  No function matches the given name and argument types. You may need
> to add explicit type casts.
>
> My function is declared like this:
>
> Function base.inserirPontos(char(1), varchar(255), numeric(12,2), int8,
> int8, int8 ) returns boolean
>
> What I did wrong ?

Looks like 9877000000944005 is too big for an int8 and it is trying to 
find a similar function with bigint instead of integer.

So try bigint as your 5th parameter type.

Anton

--
Forgiveness is giving up all hope for a better past