INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > PostgreSQL Inc.: PostgreSQL Forum

quotes around text

Read More Threads Like This One

MrTom (Programmer)

29 Jul 02 12:12

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 (Programmer)

29 Jul 02 15:07

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 (Programmer)

31 Jul 02 5:36

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 (Programmer)

31 Jul 02 14:41

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 (Programmer)

12 Aug 02 9:30

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

"myFunc"('test')

not

"myFunc('test')"

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To PostgreSQL Inc.: PostgreSQL