functions with same name, different args

Started by Brett McCormickover 28 years ago3 messageshackers
Jump to latest
#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 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
bruce@momjian.us
In reply to: Thomas 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