X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0EEDB529BD
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Fri, 29 Jul 2005 09:56:57 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 32818-03
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Fri, 29 Jul 2005 12:56:49 +0000 (GMT)
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id 176DC52998
	for <pgsql-bugs@postgresql.org>; Fri, 29 Jul 2005 09:56:49 -0300 (ADT)
Received: by svr2.postgresql.org (Postfix, from userid 80)
	id 1166CF0B14; Fri, 29 Jul 2005 13:52:45 +0100 (BST)
To: pgsql-bugs@postgresql.org
Subject: BUG #1797: Problem using Limit in a function, seqscan
From: "Magno Leite" <magnomilk@yahoo.com.br>
Message-Id: <20050729125245.1166CF0B14@svr2.postgresql.org>
Date: Fri, 29 Jul 2005 13:52:45 +0100 (BST)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200507/248
X-Sequence-Number: 12411


The following bug has been logged online:

Bug reference:      1797
Logged by:          Magno Leite
Email address:      magnomilk@yahoo.com.br
PostgreSQL version: 8.0
Operating system:   Windows XP Professional Edition
Description:        Problem using Limit in a function, seqscan
Details: 

I looked for about this problem in BUG REPORT but I can't find. This is my
problem, when I try to use limit in a function, the Postgre doesn't use my
index, then it use sequencial scan. What is the problem ?