X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9C68475CE5 for ; Thu, 27 Feb 2003 23:01:16 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 64178-08 for ; Thu, 27 Feb 2003 23:01:01 -0500 (EST) Received: from terra.inf.ufsc.br (terra.inf.ufsc.br [150.162.60.10]) by postgresql.org (Postfix) with ESMTP id 10D78475C2B for ; Thu, 27 Feb 2003 22:44:47 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by terra.inf.ufsc.br (Departamento de Informatica e Estatistica (INE/CTC/UFSC)) with ESMTP id 690CB18E0F for ; Fri, 28 Feb 2003 00:44:50 -0300 (BRT) Received: from localhost (netuno.inf.ufsc.br [150.162.60.11]) by terra.inf.ufsc.br (Departamento de Informatica e Estatistica (INE/CTC/UFSC)) with ESMTP id CFBD818FED for ; Fri, 28 Feb 2003 00:44:48 -0300 (BRT) Received: from 200.135.30.172 ( [200.135.30.172]) as user victor@imap.inf.ufsc.br by webmail.inf.ufsc.br with HTTP; Fri, 28 Feb 2003 00:44:49 -0300 Message-ID: <1046403889.3e5edb3123a74@webmail.inf.ufsc.br> Date: Fri, 28 Feb 2003 00:44:49 -0300 From: victor@inf.ufsc.br To: pgsql-sql@postgresql.org Subject: calling a stored procedure via pqSendQuery MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 200.135.30.172 X-Virus-Scanned: by AMaViS 0.3.12pre5 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/610 X-Sequence-Number: 12008 Hi, I've created a stored procedure called test(). Ok, then within a program I wrote in C I tried to call that function, but i= t=20 results in a error: "The function test() does not exist".. But, when I call a built-in function like now(), I got no errors... There is a special way to create my procedure?? Or the problem is with my C program??=20 please help! Thanks..