Re: LIMIT problem - Mailing list pgsql-sql

From Nilesh Govindarajan
Subject Re: LIMIT problem
Date
Msg-id 4BDAD39C.2090207@itech7.com
Whole thread Raw
In response to LIMIT problem  (silly sad <sad@bankir.ru>)
Responses Re: LIMIT problem
List pgsql-sql
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
मेरा भारत महान !
मम भारत: महत्तम भवतु !


pgsql-sql by date:

Previous
From: silly sad
Date:
Subject: LIMIT problem
Next
From: Jasen Betts
Date:
Subject: Re: LIMIT problem