On 05/01/10 03:58, Jasen Betts wrote:
On 2010-04-30, silly sad wrote:
suppose i request
SELECT foo(t.x) FROM t LIMIT 1;
Whither it DEFINED how many times foo() will be executed?
foo will be executed repeatedly until it returns a result or all the
rows in t are exhausted.
May anyone rely o
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
On 2010-04-30, silly sad wrote:
> suppose i request
>
> SELECT foo(t.x) FROM t LIMIT 1;
>
> Whither it DEFINED how many times foo() will be executed?
foo will be executed repeatedly until it returns a result or all the
rows in t are exhausted.
> May anyone rely on it?
not sure
> Or we have to
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 r
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?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresq