X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (unknown [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id CEDC69FB2F7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 30 Aug 2006 09:52:40 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 26937-02-4 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 30 Aug 2006 09:52:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175])
	by postgresql.org (Postfix) with ESMTP id 8B59D9FB2F8
	for <pgsql-sql@postgresql.org>; Wed, 30 Aug 2006 09:50:50 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id m3so179547ugc
	for <pgsql-sql@postgresql.org>; Wed, 30 Aug 2006 05:50:48 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=kWz0LdUZcjmgS27LDHw33yS/Z0oIw6+IyZbox+9DFvV3ah3KbQftnXmnLE3DRHsWfYMY5C8hl8MSe6MXVF28hlznWCvOE9Lch4QpAHdC30T2a8TYtL3SN9hc6PKDpQQob3nsVAWjaf3vDMy0dsSU8XNiDdcNz5TTMV7pfejZE30=
Received: by 10.66.216.6 with SMTP id o6mr445992ugg;
	Wed, 30 Aug 2006 05:50:47 -0700 (PDT)
Received: by 10.67.118.11 with HTTP; Wed, 30 Aug 2006 05:50:47 -0700 (PDT)
Message-ID: <55c095e90608300550l35a9f71dv50b13945f1de17b2@mail.gmail.com>
Date: Wed, 30 Aug 2006 09:50:47 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Error on function parameters
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_34460_20587090.1156942247355"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.851 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200608/237
X-Sequence-Number: 26195

------=_Part_34460_20587090.1156942247355
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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.
--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_34460_20587090.1156942247355
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list<br><br>I am doing an statement like this:<br><br>select insertPoint=
s('C', '123456789', 12.5, 1, 9877000000944005, 104)<br><br>and get the foll=
owing error:<br><br><span style=3D"font-weight: bold;">ERROR:&nbsp; functio=
n inserirpontos(&quot;unknown&quot;, &quot;unknown&quot;, numeric, integer,=
 bigint, integer) does not exist
</span><br style=3D"font-weight: bold;"><span style=3D"font-weight: bold;">=
HINT:&nbsp; No function matches the given name and argument types. You may =
need to add explicit type casts.</span><br style=3D"font-weight: bold;" cle=
ar=3D"all">
<br>My function is declared like this:<br><br>Function base.inserirPontos(c=
har(1), varchar(255), numeric(12,2), int8, int8, int8 ) returns boolean<br>=
<br>&nbsp;What I did wrong ?<br><br>Please help me.<br>-- <br> =3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (S=
incerely)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;Ezequias Rodrigues da Rocha<br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-<br>A pior das democracias ainda =E9 melho=
r do que a melhor das ditaduras
<br>The worst of democracies is still better than the better of dictatorshi=
ps<br> <a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.=
blogspot.com/</a>

------=_Part_34460_20587090.1156942247355--