From: Michael Glaesemann <grzm@myrealbox.com>
To: Juris <bubliks@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: Thu, 19 Jan 2006 21:48:30 +0900
Message-ID: <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com> (raw)
In-Reply-To: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@myrealbox.com, bubliks@gmail.com
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
In-Reply-To: <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox