Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E975E633A4E for ; Tue, 10 Aug 2010 13:48:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 08361-08 for ; Tue, 10 Aug 2010 16:48:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id 41FF6633276 for ; Tue, 10 Aug 2010 13:48:18 -0300 (ADT) Received: (qmail invoked by alias); 10 Aug 2010 16:48:16 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp006) with SMTP; 10 Aug 2010 18:48:16 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+WrwAE72SWI8E4IFu3rWORki7Co8WxFlYMemGlhM ZkUKVR6j8x1tvP Subject: Re: type cast From: Peter Eisentraut To: Imre Horvath Cc: pgsql-sql@postgresql.org In-Reply-To: <1281458286.7072.2.camel@cytherian.blemidon.dyndns.org> References: <1281458286.7072.2.camel@cytherian.blemidon.dyndns.org> Content-Type: text/plain; charset="UTF-8" Date: Tue, 10 Aug 2010 19:48:14 +0300 Message-ID: <1281458894.8626.0.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.2 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-5 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/44 X-Sequence-Number: 34484 On tis, 2010-08-10 at 18:38 +0200, Imre Horvath wrote: > Hi! > > I don't know if it's the right place or the psycopg2 list: > > I've got a plpython function, with a character varying param. > I can call it from sql. > But when i try to call it with psycopg2.callproc('testfunc', ['test']), > i've got the error: > function testfunc(unknown) does not exist > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. psycopg list. But you should add version information about psycopg and PostgreSQL.