Error on function parameters - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Error on function parameters
Date
Msg-id 55c095e90608300550l35a9f71dv50b13945f1de17b2@mail.gmail.com
Whole thread Raw
Responses Re: Error on function parameters
Re: Error on function parameters
List pgsql-sql
Hi list<br /><br />I am doing an statement like this:<br /><br />select insertPoints('C', '123456789', 12.5, 1,
9877000000944005,104)<br /><br />and get the following error:<br /><br /><span style="font-weight: bold;">ERROR: 
functioninserirpontos("unknown", "unknown", numeric, integer, bigint, integer) does not exist </span><br
style="font-weight:bold;" /><span style="font-weight: bold;">HINT:  No function matches the given name and argument
types.You may need to add explicit type casts.</span><br clear="all" style="font-weight: bold;" /><br />My function is
declaredlike this:<br /><br />Function base.inserirPontos(char(1), varchar(255), numeric(12,2), int8, int8, int8 )
returnsboolean<br /><br /> What I did wrong ?<br /><br />Please help me.<br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a> 

pgsql-sql by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Trigger with Stored Procedure [Client Points]
Next
From: Tom Lane
Date:
Subject: Re: Error on function parameters