Schwarz, Karl wrote:
Is there something basic I am missing here with the use of a function. I am no database expert, but my assumption was that a function would give me better results than in-line sql.
Not necessarily. Usually it means the planner has less information to go on.We'll need more information though - table definitions, queries, how is the function called etc.
-- Richard Huxton Archonet Ltd
