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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
