On Sat, 19 Apr 2003, Rajesh Kumar Mallah wrote:
> If I limit a particular query to show 3 results which has a function call
> how can the function get called 4 times ? its apparently happening to me.
In versions before 7.4 I think it grabbed one extra row beyond what you
specify for the limit and then doesn't return that row, so if you say
limit 3 it gets 4 rows (and thus calls the function 4 times). This
appears to be different in 7.4.