Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" - Mailing list pgsql-sql

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