From: silly sad <sad@bankir.ru>
To: pgsql-sql@postgresql.org
Subject: Re: LIMIT problem
Date: Sat, 01 May 2010 12:55:21 +0400
Message-ID: <4BDBEC79.9080008@bankir.ru> (raw)
In-Reply-To: <4BDAD39C.2090207@itech7.com>
References: <4BDAD20A.1090503@bankir.ru>
<4BDAD39C.2090207@itech7.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sad@bankir.ru
Subject: Re: LIMIT problem
In-Reply-To: <4BDBEC79.9080008@bankir.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox