X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 24FE84758C9 for ; Sat, 19 Apr 2003 02:50:27 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 676A4476128 for ; Sat, 19 Apr 2003 02:50:11 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 978E1D626; Fri, 18 Apr 2003 23:50:09 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 8D4845C02; Fri, 18 Apr 2003 23:50:09 -0700 (PDT) Date: Fri, 18 Apr 2003 23:50:09 -0700 (PDT) From: Stephan Szabo To: Rajesh Kumar Mallah Cc: Subject: Re: apparent problem with a PL In-Reply-To: <200304191129.39347.mallah@trade-india.com> Message-ID: <20030418234848.N10642-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-16.1 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/298 X-Sequence-Number: 12999 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.