X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CAE519DCA56 for ; Thu, 19 Jan 2006 08:48:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10616-01 for ; Thu, 19 Jan 2006 08:48:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143]) by postgresql.org (Postfix) with ESMTP id 2708E9DC940 for ; Thu, 19 Jan 2006 08:48:31 -0400 (AST) Received: from [172.16.1.181] grzm [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux; Thu, 19 Jan 2006 05:48:33 -0700 In-Reply-To: <4f31e3850601190439s6b00f6bfj@mail.gmail.com> References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Date: Thu, 19 Jan 2006 21:48:30 +0900 To: Juris X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.066 required=5 tests=[AWL=-0.266, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.066 X-Spam-Level: * X-Archive-Number: 200601/128 X-Sequence-Number: 23917 On Jan 19, 2006, at 21:39 , Juris wrote: > == sql begin == > CREATE OR REPLACE FUNCTION "InventGroups_GetAllParents"(int8) > select * from InventGroups_GetAllParents(0::int8) > ======= > ERROR: function inventgroups_getallparents(bigint) does not exist > HINT: No function matches the given name and argument types. You may > need to add explicit type casts. If you double-quote your function name (or any identifier) when you create it, you'll need to double-quote them when you call the function as well. Try: select * from "InventGroups_GetAllParents"(0::int8) Michael Glaesemann grzm myrealbox com