Re: apparent problem with a PL - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: apparent problem with a PL
Date
Msg-id 20030418234848.N10642-100000@megazone23.bigpanda.com
Whole thread Raw
In response to apparent problem with a PL  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: apparent problem with a PL
List pgsql-sql
On Sat, 19 Apr 2003, Rajesh Kumar Mallah wrote:

> If I limit  a particular query to show 3 results which has a function call
> how can the function get called 4 times ? its apparently happening to me.

In versions before 7.4 I think it grabbed one extra row beyond what you
specify for the limit and then doesn't return that row, so if you say
limit 3 it gets 4 rows (and thus calls the function 4 times).  This
appears to be different in 7.4.



pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: replicable problem with PL/Perl
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: apparent problem with a PL