From: Nilesh Govindarajan <lists@itech7.com>
To: pgsql-sql@postgresql.org
Subject: Re: LIMIT problem
Date: Fri, 30 Apr 2010 18:27:00 +0530
Message-ID: <4BDAD39C.2090207@itech7.com> (raw)
In-Reply-To: <4BDAD20A.1090503@bankir.ru>
References: <4BDAD20A.1090503@bankir.ru>
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
मेरा भारत महान !
मम भारत: महत्तम भवतु !
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: lists@itech7.com
Subject: Re: LIMIT problem
In-Reply-To: <4BDAD39C.2090207@itech7.com>
* 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