Skip site navigation (1) Skip section navigation (2)

Undocumented feature in CREATE INDEX...

From: Jeffery Collins <collins(at)onyx-technologies(dot)com>
To: docs(at)postgresql(dot)org
Subject: Undocumented feature in CREATE INDEX...
Date: 2000-05-18 18:25:39
Message-ID: 392435A3.FF2DD4E6@onyx-technologies.com (view raw or flat)
Thread:
Lists: pgsql-docs
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



Responses

pgsql-docs by date

Next:From: He Weiping (laser henry)Date: 2000-05-19 22:40:59
Subject: It' seems there are some problem in document about pl/tcl
Previous:From: Vince VielhaberDate: 2000-05-17 10:40:55
Subject: Re: [OFF TOPIC]Traducción

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group