function problem

Started by ABHANG RANEalmost 19 years ago2 messagesgeneral
Jump to latest
#1ABHANG RANE
arane@indiana.edu

Hi,
I have written a function called similarity in postgresql which accepts
real[] as argument. I then call it by saying

select * from similarity('{1.232,5.0000, 5.100, 10000}');

I get this error.

Could not choose a best candidate function. You may need to add
explicit type casts.

Is it the way I call is wrong?

Thanks
Abhang

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: ABHANG RANE (#1)
Re: function problem

ABHANG RANE <arane@indiana.edu> writes:

I have written a function called similarity in postgresql which accepts
real[] as argument. I then call it by saying

select * from similarity('{1.232,5.0000, 5.100, 10000}');

I get this error.

Could not choose a best candidate function. You may need to add
explicit type casts.

Apparently you've got more than one function named "similarity".
If that wasn't intentional, get rid of the bogus ones. If it was,
cast your constant to make it clear which type you intend.

regards, tom lane