Re: LIMIT problem - Mailing list pgsql-sql

From silly sad
Subject Re: LIMIT problem
Date
Msg-id 4BDBEC79.9080008@bankir.ru
Whole thread Raw
In response to Re: LIMIT problem  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-sql
On 04/30/10 16:57, Nilesh Govindarajan wrote:
> 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.

I did not asked how many times foo() would be executed.


pgsql-sql by date:

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