Re: LIMIT problem

On 04/30/2010 06:20 PM, silly sad wrote:
> suppose i request
>
> SELECT foo(t.x) FROM t LIMIT 1;
>
> Whither it DEFINED how many times foo() will be executed?
>
> May anyone rely on it?
> Or we have to avoid this non SQLish trick?
>

It will execute foo only once, and give only one row out of the n rows 
it returns. If I'm wrong please correct me.

-- 
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
मेरा भारत महान !
मम भारत: महत्तम भवतु !