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

Argh... big thanks.. did not know what pgAdmin/PG have any
case-sensitive issues with functions...

Also for fields it is relative... without dbl-quotes i could not query
anything (i am using "MySuperField"-like field names)

2006/1/19, Michael Glaesemann <grzm@myrealbox.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
>
>
>
>