functions with same name, different args

Started by Brett McCormickalmost 28 years ago3 messages
#1Brett McCormick
brett@abraxas.scene.com

I notice that all the functions with the same name but different args
are actually sql statements which SELECT the result of the function
call using a different (and unique) name..

Wouldn't this cause slowdowns? Shouldn't you be able to have a
different name for your function in pgsql than in the shared library,
without having to resort to such hacks?

--brett

#2Thomas G. Lockhart
lockhart@alumni.caltech.edu
In reply to: Brett McCormick (#1)
Re: [HACKERS] functions with same name, different args

I notice that all the functions with the same name but different args
are actually sql statements which SELECT the result of the function
call using a different (and unique) name..

Wouldn't this cause slowdowns? Shouldn't you be able to have a
different name for your function in pgsql than in the shared library,
without having to resort to such hacks?

Actually, we were pretty happy when Edmund Mergl found this mechanism.
I've thought about making changes to allow compiled code to do the same
thing, but we've had other more important issues to work on. Send
patches if you want something different.

#3Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Thomas G. Lockhart (#2)
Re: [HACKERS] functions with same name, different args

I notice that all the functions with the same name but different args
are actually sql statements which SELECT the result of the function
call using a different (and unique) name..

Wouldn't this cause slowdowns? Shouldn't you be able to have a
different name for your function in pgsql than in the shared library,
without having to resort to such hacks?

Actually, we were pretty happy when Edmund Mergl found this mechanism.
I've thought about making changes to allow compiled code to do the same
thing, but we've had other more important issues to work on. Send
patches if you want something different.

Actually the problem was that SQL functions can compare args and call
the proper function, while C functions just get called without any arg
comparisons.

--
Bruce Momjian
maillist@candle.pha.pa.us