From: | Anton de Wet <adw(at)obsidian(dot)co(dot)za> |
---|---|
To: | Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Error on function parameters |
Date: | 2006-08-30 13:06:05 |
Message-ID: | Pine.LNX.4.64.0608301504460.9300@Amenhotep.obsidian.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marcelo . | 2006-08-30 13:52:28 | Re: UTF8 Vs Latin9 and valid encoding. |
Previous Message | Tom Lane | 2006-08-30 12:58:53 | Re: Error on function parameters |