quotes around text

[MrTom]

i have a function which takes type text as input.

when i try to call the function with

select myfunc('test');

it says

Function 'myfunc(unknown)' does not exist

why does is not know that 'test' is a string? am i using the wrong quotes or what?

as a sanity check, doing

select myfunc(4);

tells me

Function 'myfunc(int4)' does not exist

which is what i'd expect.

 

[rycamor]

It's hard to say, without seeing at least the initializer part of your function code. -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)

 

[MrTom]

hmmm.... my function had upper case characters in it's name, like "myFunc".

doing a \df showed that it was called "myfunc" (without the upper case) and trying to call the function as "myfunc('text')" or "myFunc('text')" failed.

i guess maybe pg wanted some "'s around the function name " "myFunc"('text') " but it was giving me the wrong error mesg.

i didn't test this as i just put the whole function name in lower case and that worked.

 

[rycamor]

Yes, PostgreSQL is very fussy about case. Best to just stick to lower case names for functions, tables, and attributes whenever possible. -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)

 

[postwick]

If case sensitivity is your problem, then you need to do this:

"myFunc"('test')

not

"myFunc('test')"