Received: from onyx-technologies.com (200-216.205.44.interliant.com
	[216.205.44.200] (may be forged))
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA99107
	for <docs@postgresql.org>; Thu, 18 May 2000 15:27:36 -0400 (EDT)
	(envelope-from collins@onyx-technologies.com)
Received: from onyx-technologies.com (collins.onyx-technologies.com
	[192.168.188.10])
	by onyx-technologies.com (8.9.2/8.9.0) with ESMTP id PAA11216
	for <docs@postgresql.org>; Thu, 18 May 2000 15:26:30 -0400 (EDT)
Message-ID: <392435A3.FF2DD4E6@onyx-technologies.com>
Date: Thu, 18 May 2000 14:25:39 -0400
From: Jeffery Collins <collins@onyx-technologies.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: docs@postgresql.org
Subject: Undocumented feature in CREATE INDEX...
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200005/17

While perusing the CreateIndex source and the parse table, I noticed
that CREATE INDEX supports a WITH clause.  The only value that can be
specified in the WITH clause is "islossy".

So the following statement will parse correctly and will actually set
the 'isloosy' flag on in the index.

    CREATE INDEX foo_bar_index ON foo (bar) WITH (islossy) ;

This isn't documented in the User's manual .  It probably isn't real
important, I just thought I would mention it.

Jeff