Received: from ns.krot.org (ns.krot.org [193.212.103.165])
	by postgresql.org (8.11.3/8.11.4) with SMTP id f9CKd5r18427
	for <pgsql-sql@postgresql.org>; Fri, 12 Oct 2001 16:39:05 -0400 (EDT)
	(envelope-from postgresql@envisity.com)
Received: (qmail 27860 invoked by uid 67); 12 Oct 2001 20:37:17 -0000
Message-ID: <20011012203717.5334.qmail@ns.krot.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
MIME-Version: 1.0
From: "Aasmund Midttun Godal" <postgresql@envisity.com>
To: pgsql-sql@postgresql.org
Subject: Indexes
Date: Fri, 12 Oct 2001 20:37:17 GMT
X-Mailer: Googley-Moogley
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id
	f9D28HJ24163
X-Archive-Number: 200110/161
X-Sequence-Number: 5116

Can someone shed some light on as to how the indexes actually work?

I want to index the results of a function, the function does a whole lot of different selects on different tables. Will the database know when to update the index.

If there already is some documentation on this (besides the source...) I would be glad to know.

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46