Re: LIMIT problem

From: silly sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: LIMIT problem
Date: 2010-05-01 08:55:21
Message-ID: 4BDBEC79.9080008@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message silly sad 2010-05-01 09:05:11 Re: LIMIT problem
Previous Message Jasen Betts 2010-04-30 23:58:15 Re: LIMIT problem