fabiano_bonin wrote:

>
> I expected the procedure would be evaluated just one time using the
> first parameter it received, giving me the following result:

I don't think that makes sense, but I'm not entirely sure that I
understand the whole logic of joins and stored procedures. However,
I can tell you that both Firebird 2 alpha 3 and Vulcan produce the
results you saw - in a left join with the stored procedure last,
the procedure is invoked once for each row produced by the right
hand side of the query.


Regards,


Ann