Re: Stored function question

Since the item in the where clause would be a stored function returning boolean, you would have to pass it everything it needs to return and answer, such as:

   Function Is_Preferred_Customer (field1, field2, field3....etc)    return Boolean as
   .....if field1='a', etc......
   return TRUE.

Remember that the where clause will be executed for every row of customers, and will be slower that raw SQL. There will also be no opportunity for optimizer to look for indexes on various fields since they are now buried in the function call.

Robert Proffitt
Beckman Coulter
Brea California

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 19:09:37 CDT