Error on function parameters

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Error on function parameters
Date: 2006-08-30 12:50:47
Message-ID: 55c095e90608300550l35a9f71dv50b13945f1de17b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?

Please help me.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-08-30 12:58:53 Re: Error on function parameters
Previous Message Ezequias Rodrigues da Rocha 2006-08-30 11:56:32 Trigger with Stored Procedure [Client Points]