From: | Juris <bubliks(at)gmail(dot)com> |
---|---|
To: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" |
Date: | 2006-01-19 13:06:05 |
Message-ID: | 4f31e3850601190506s71a41cc9t@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)myrealbox(dot)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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | T E Schmitz | 2006-01-19 15:41:25 | indexing for left join |
Previous Message | Michael Glaesemann | 2006-01-19 12:48:30 | Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" |