From: Juris <bubliks@gmail.com>
To: Michael Glaesemann <grzm@myrealbox.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 15:06:05 +0200
Message-ID: <4f31e3850601190506s71a41cc9t@mail.gmail.com> (raw)
In-Reply-To: <324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
References: <4f31e3850601190439s6b00f6bfj@mail.gmail.com>
<324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com>
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
>
>
>
>
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: bubliks@gmail.com, grzm@myrealbox.com
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
In-Reply-To: <4f31e3850601190506s71a41cc9t@mail.gmail.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