I'd be in favour of removing the distinction - a few people have asked me about the difference.
> It's a historic thing - procedures actually appeared in > early versions of EnterpriseDB originally where they were > considered different objects from functions if memory > serves. The distinction remained when 8.1 was > released. I'm happy to discuss re-engineering that if people > want (can't guarantee I'll actually get time to change > anything myself though). Send instant messages to your online friends http://uk.messenger.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match