Jim, > Yes, but using overloading to implement defaults is a pain. Imagine how > much you need to overload to have 5 default arguments; that equates to 4 > stub functions/prodecudes. In the case of adding a single parameter it's > not that bad, but it becomes very onerous if you're trying to provide > default values for a bunch of parameters.
See follow-up discussion regarding ambiguity within overloading schemes. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match